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))))

Find more posts tagged with

Formulas

Accepted answers

All comments

Paul Newcome

What are the rest of your formulas?

Viktor Palles

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

Paul Newcome

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.