Even though I’m feeling pleased about getting something to work, I suspect I’m doing it entirely wrong.
I’ve built a simple calculator but instead of figuring out how to pull data from sheets I did it using if/then/else. Clearly, placing sheet variables in by hand is just stupid, but I got all confused by the combination of Choice, Form, Math, Relations and If/then components.
What I have is a cost estimator for the square footage of applying various materials at various prices using various methods. People only need to input the sq ft and select the material / application method and it should spit out the amount required and total cost based on set per gallon costs. I don’t currently wish to save any of the calculations to a sheet.
It should be so simple, compared to what I’ve seen, that I’m embarrassed to even ask. How many sheets should I consider using in addition to the supplementary columns in Data?