What am I doing wrong? It's not working. Frustrated

I can not figure out why my formulas on Google Sheet will not work on APP SHEET.

I wish there was an easier way.

And go…

@Jon_Geer Sorry to hear you are having trouble. I’m sure someone here can help but we need a few details.

I see no major issues with the table in your image. “Gallons pumped” should probably be a Number or Decimal datatype but that shouldn’t cause big problems.

You mentioned problems with formulas. What specifically are you having issues with?

Please refer to this page for sheet formulas: