3 ms·
I really wish spreadsheets had a way to loop over rows and columns. Currently I have to create a huge mess of ARRAYFORMULAs whenever I need to apply some comput
by matheusmoreira 6y ago
I really wish spreadsheets had a way to loop over rows and columns. Currently I have to create a huge mess of ARRAYFORMULAs whenever I need to apply some computation to all rows. I use my spreadsheets as databases and I want them to calculate new information as soon as I input new data. This use case should not be so hard...
- ako 6y agovba?
- selimthegrim 6y agohttp://www.blockpad.net http://www.blockpad.net might fit your use case
- matheusmoreira 6y agoYeah, using an actual programming language would probably solve all this complexity. I'm using Google Sheets though and I absolutely need everything to be fully functional in the mobile app so I'm not sure how far I can take it with the javascripting. The app doesn't even support editing pivot tables.