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
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.
User | Count |
---|---|
14 | |
11 | |
9 | |
7 | |
4 |