If project status complete - stop calculating formulas & Conditional Formatting
Greetings,
Currently at row 1600, waiting for a cell's formula to process the formula may take up to 10 minutes. For instance, sometimes when I change the duration of a Child row by 1 day, it may take 10 minutes for the End Date to advance by 1 day.
I use A LOT of formulas, cross-sheet references, as well as Conditional Formatting.
Is there something I may add to my formulas (or a Rule to the Sheet) where Smartsheet stops looking at completed rows (Reprocessing formulas, Durations, Conditional Formatting)?
Due to the loss of formulas, I cannot move most of the completed projects to another Sheet because there is an opportunity for the project to become reactivated due to client-requested changes.
Thanks - Dan
Comments
-
Hi there. It is a known issue that conditional formatting will downgrade Smartsheet performance. Try disabling all your conditional formatting and see if that increases performance. If that helps performance, consider consolidating or minimizing the number of conditional formulas you use.
-
Hi Dan,
Look to see if you can update formulas with @row and @cellto make the sheet more efficient.
I hope this helps you!
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!