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

Find more posts tagged with

Sheets

Formulas

Conditional Formatting

Cell linking

Enhancement Request

Comments

Mike Wilday

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.

Andrée Starå

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

Sign in to join the conversation!

Quick Links

Trending discussions

Dynamic formula to return date of next Thursday every week.
I'm wondering if anyone has worked out a dynamic formula to return the date of the 'next' Thursday of the month. I have a worksheet where I need to send out a reminder to a contacts in a contact column in the worksheet each Thursday of the current month if a criteria has not been met. When criteria has been met, then…
Check box for date in previous month
Hello, I have the formula to check a box for line items with the current month. =IF(AND(YEAR(Date@row ) = YEAR(TODAY()), MONTH(Date@row ) = MONTH(TODAY())), 1, 0) Trying to set up a report for all items with the previous month (i.e. 1 month prior to current). How can I modify to check the box?
Need Help with If, Index, Collect
Please help, I have a few of these to do. I have a nested IF formula. The first part is an INDEX/MATCH and works as a standalone. The next few are INDEX/COLLECT. These are not working as standalone or in the nested version (Unparsable Error). Any ideas? =IF(CONTAINS(“A/V”, [Vendor Type]@row ), INDEX(COLLECT({Date Secured…