[a / b / c / d / e / f / g / gif / h / hr / k / m / o / p / r / s / t / u / v / vg / vm / vmg / vr / vrpg / vst / w / wg] [i / ic] [r9k / s4s / vip / qa] [cm / hm / lgbt / y] [3 / aco / adv / an / bant / biz / cgl / ck / co / diy / fa / fit / gd / hc / his / int / jp / lit / mlp / mu / n / news / out / po / pol / pw / qst / sci / soc / sp / tg / toy / trv / tv / vp / vt / wsg / wsr / x / xs] [Settings] [Search] [Mobile] [Home]
Settings Mobile Home
/wsr/ - Worksafe Requests

Thread archived.
You cannot reply anymore.

[Advertise on 4chan]

File: Capture.png (12 KB, 798x150)
12 KB
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]
File: Capture.png (25 KB, 1349x204)
25 KB
separate ingredient count from amount required into their own columns, dealing with strings is tedious
I just removed those columns entirely and added a 'can be made' column, you can add them back
That'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?
Checkbox cells are just booleans (0 or 1), so "ingredient used" is just
"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 made

I know it's a bit unclear; I'm phoneposting. When I get computer access I'll share the sheet
It's very clear, thank you so much. I got it working but would definitely appreciate being able to double check with your sheet
Upload to Google Sheets and replace the checkboxes

[Advertise on 4chan]

Delete Post: [File Only] Style:
[Disable Mobile View / Use Desktop Site]

[Enable Mobile View / Use Mobile Site]

All trademarks and copyrights on this page are owned by their respective parties. Images uploaded are the responsibility of the Poster. Comments are owned by the Poster.