# Semi simple math calculations with drop-down choices **URL:** \ **Category:** Ask for Help\ **Created:** [November 22, 2019, 8:18pm UTC](https://community.glideapps.com/t/semi-simple-math-calculations-with-drop-down-choices/2305 "2019-11-22T20:18:21Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![Les\_Henderson](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/les_henderson/32/1142_2.png) [@Les\_Henderson](https://community.glideapps.com/u/Les_Henderson)\ **Post date:** [November 22, 2019, 8:18pm UTC](https://community.glideapps.com/t/semi-simple-math-calculations-with-drop-down-choices/2305/1 "2019-11-22T20:18:21Z")
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? ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [November 23, 2019, 3:51pm UTC](https://community.glideapps.com/t/semi-simple-math-calculations-with-drop-down-choices/2305/2 "2019-11-23T15:51:33Z")
I can see where you are stuck. This would probably require per user data and a record for each user as the values would ultimately be saved to the sheet. I’m starting to think that it would be beneficial to have the ability to add/ edit values that would not be updated back to the spreadsheet. This would be great for your situation of a one-off calculator. ---
**Author:** ![Krivo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/krivo/32/5363_2.png) [@Krivo](https://community.glideapps.com/u/Krivo)\ **Post date:** [November 23, 2019, 4:03pm UTC](https://community.glideapps.com/t/semi-simple-math-calculations-with-drop-down-choices/2305/3 "2019-11-23T16:03:23Z")
@Jeff_Hager It would be great with “session based” calculations. Actually, I would like the G-sheet to do calculations but without saving the data in the sheet when the session has ended. I would like to have some really neat charts shown as well based on the data - just inputted in the session. ---
**Author:** ![Les\_Henderson](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/les_henderson/32/1142_2.png) [@Les\_Henderson](https://community.glideapps.com/u/Les_Henderson)\ **Post date:** [November 23, 2019, 7:10pm UTC](https://community.glideapps.com/t/semi-simple-math-calculations-with-drop-down-choices/2305/4 "2019-11-23T19:10:59Z")
That’s the thing. Since it’s reliant more upon the Data sheet, it’s currently only saving/overwriting the top row “area” input entry on the supporting Google sheet, which is great since I don’t want to save hundreds of such calculations. Much the same for the Data Sheet. > **[Image 2019-11-23 at 2.06.04 PM.png](https://share.getcloudapp.com/QwuQNAW1)** > > Shared with CloudApp I’d just like it to become more complex with another choice component or two. ---
**Author:** ![Les\_Henderson](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/les_henderson/32/1142_2.png) [@Les\_Henderson](https://community.glideapps.com/u/Les_Henderson)\ **Post date:** [November 23, 2019, 7:13pm UTC](https://community.glideapps.com/t/semi-simple-math-calculations-with-drop-down-choices/2305/5 "2019-11-23T19:13:07Z")
Maybe I somehow created what you are looking for, minus the charts of course?