Efficient Format of Functions

AppSheet AppSheet Q&A
1

I have an app that has multiple Google Sheets with the function “=Max(0,D1-E1)” for each row number but there is over 60,000 rows total. i was wondering if there was a more efficient way of writing this since i plan on adding more as time goes on and would like to keep it running as smoothly as possible in the future. thank you for any help!

https://docs.google.com/spreadsheets/d/1XRqjFwzAsX8XmXKJKNlzGDnF42coSE6G0r7XVzvFlqo/edit?usp=sharing

here is an example sheet if you’re interested in seeing the current format

2

This is an AppSheet Commmunity Forum. You can build apps using the Google sheet as a datasource but It doesn’t look like your sheet is setup that way. So I assume this is just a basic Google Sheets question. I would recommend finding an appropriate Google Sheets forum to ask your question in. They would be better able to more accurately answer your question.

2 Likes