Performance issues
Hi All,
I have 4 sheets with 5000+ rows & with 4 column formulas. I would need to add a 5th formula, which looks like as stated below. When I added it the sheet started to slow down, it was freezing, since the formula runs on the cell basis. Is there an option to optimize the sheets' performance, when cell formulas are running?
=IF(Alias2 = Alias1, "", (COUNTIF($Alias$1:$Alias$5062, $Alias1) * (25 / 365)) * (AVERAGEIF($Alias$1:$Alias$5062, $Alias1, $[Individual_Daily_Target]$1:$[Individual_Daily_Target]$5062)) - ((COUNTIFS($Alias$1:$Alias$5062, $Alias1, $[Type_of_Absence]$1:$[Type_of_Absence]$5062, "Vacation")) * (AVERAGEIF($Alias$1:$Alias$5062, $Alias1, $[Individual_Daily_Target]$1:$[Individual_Daily_Target]$5062))))
Answers
-
What are the rest of your formulas?
-
The rest of the formulas are percentage calculations, like:
=IF([Day_worked]@row = 1, ([Category_Daily_Target]@row * [Classification_Time (%)]@row), (([Category_Daily_Target]@row * [Classification_Time (%)]@row) * [Day_worked]@row))
Thanks
-
DO you have any cross sheet references or cell links? Do you have a lot of automations and/or conditional formatting? All three of those things will definitely impact sheet performance.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 462 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!