Dropdown form adds extra sum functions to Google Sheet

I am trying to build a simple app to input mileage for drivers to calculate the cost for driving between specific buildings. In the past, we have used a spreadsheet with formulas, and I want to use the app to input the data into the spreadsheet. I set it up to use a dropdown for “To” and “From”, and then also input the date. When the data is put onto the sheet, it adds a “sum” function in the next two cells. I can’t figure out what I’ve done wrong, so I figure I’ll ask around before I scrap the app and start again. Any ideas?

you could share screenshots of your app?

1 Like