u/rmalev91

Recipe name spits out all the components. And then if I want to make 3 of that recipe for an occasion it scales. I've been searching on Google, reddit, and YouTube and I can't find a solution. I could be searching the wrong terms but I'm at a loss.

For example, I have a recipe for pbj. I'd like to be able to have a drop down for pbj and if each one needs 0.5oz of peanut butter and 0.5oz of grape jelly then if I want to make 10 of them it tells me how much of each I need.

I remember while learning coding way back when and learning about objects and them being able to have multiple fields attributed to them. But from what I've dug up I can't seem to to do that with sheets.