How can I do the following using picrel as a model?>fill total ingredient count in the far right table>get it to automatically fill the ingredient count / amount required columns in the left table>subtract a meal ingredients from the ingredient count (and thus other meals) upon being checked with the checkbox columns[spoiler]I'm not cooking this is just to make it understandable[/spoiler]
separate ingredient count from amount required into their own columns, dealing with strings is tediousI just removed those columns entirely and added a 'can be made' column, you can add them back
>>1420269That's much better, thanks. Could you share how to make the ingredient used column "checkbox sensitive" please? And I imagine that the "can be made" column updates automatically?
>>1420423Checkbox cells are just booleans (0 or 1), so "ingredient used" is just =ingredient_required*checkbox"Can be made" is =AND(ing1_remaining>=ing1_required, ing2_remaining>=ing2_required)I added to the above a bit so that it doesn't turn FALSE when you run out of ingredients to become=OR(AND(checkbox, ing1_remaining>=0, ing2_remaining>=0), /* formula above here */ )This means that as long as remaining ingredients are not negative, all checked meals can be madeI know it's a bit unclear; I'm phoneposting. When I get computer access I'll share the sheet
>>1420467It's very clear, thank you so much. I got it working but would definitely appreciate being able to double check with your sheet
>>1420734https://litter.catbox.moe/cp3li4.xlsxUpload to Google Sheets and replace the checkboxes