Thank you for discussing this openly, it can be a real bummer to write something, test it, have something work up to a point then fail due to situations outside your control.
You probably just saved me about 20 hours of coding.
You probably just saved me about 20 hours of coding.
https://www.nature.com/articles/d41586-021-02211-4?error=coo...
Few years have passed, and there are currently 470 THOUSAND rows with 20+ columns in that spreadsheet which is used almost daily.
Rewriting this into a proper web app would take maybe a week (the API is already there and used by GS), but was never deemed a priority, so it will keep existing in the backlog until we hit row or cell limits - after which it will suddenly become urgent...