Forum Discussion
FILTER Function Lagging, alternative function for this case?
Thank you for your response!
Do you have an idea what other function could be used?
The lag I'm talking about is the delay between entering a number in the Team column (G), and the timeline part of the sheet updating, especially when quickly entering team numbers.
I have attached a screen recording to demonstrate. Note that as soon as I type the number, I press enter immediately, however it has a delay.
In regards to the shapes, even with the shapes removed, it is the same.
Many thanks for your help and time!
Sam
As Patrick2788 already stated the lag is only a "long" fraction of a second.
And that is because of 84240 formulas. If you remove alle formulas the lag would be gone.
- I thought this might be the case, in which case i'm out of luck.
However I just tried deleting rows 42 onwards, vastly decreasing the amount of formulas, and it is still the same?Another way to approach the sheet is to produce the results all in 1 spill. This approach has reduced the size of the workbook to less than 1 mb.
=LET( height, COUNT(ETA), width, COLUMNS(times), GetResults, LAMBDA(r, c, LET( team_number, INDEX(sched_team, r), interval, INDEX(times, , c), FILTER( team, (team_number = team) * (interval >= ETA) * (interval <= ETD), "" ) ) ), MAKEARRAY(height, width, GetResults) )A single input to get the results:
Other ways to speed up the workbook:
1. Shorten the conditional formatting ranges. Conditional formatting is an old feature that calculates on a single-thread.
2. Remove unnecessary objects from the sheet.
Well, you could remove all cond. form. rules.
