I have a sheet with ~90 columns and currently ~650 rows. The number of rows of the sheet will continue to increase. There are about 30 columns that are formula columns of which 15 use nested if statements about 7 levels deep. The sheet is used to track project roles and assignments. I have a few Dynamic Views to filter down for specific teams so that each resource manager can manage their teams' resources. The Dynamic View enables them to create new resource requests, assign new resources and to end assignments etc. The underlying Smartsheet has quite a few automations running to notify stakeholders for certain changes in status.
I am finding that the sheet is becoming increasingly slow and the Dynamic Views as well. I have tried to modify the formula to be less complex but then ran into issues with the calculation time which ended up being much longer and so was presenting an error message before eventually catching up and displaying the correct answer. Sometimes, this would require a refresh of the sheet. It is getting frustrating for my stakeholders to have to wait quite a long time for the details panel to load with the fields that they can update. Is there a way or suggested solution on how to speed up the app?
