Hi All,
I recently reached this limit for a sheet that was implemented. I have 6 columns that pull from a reference sheet. For example: =INDEX({MWN Ref: Supervisor}, MATCH([@Email]@row, {MWN Ref: @Email},0)). I don't believe that those columns are the issue.
I have two separate columns that I will paste below that I need help to simplify in order to continue their use since they are involved in several automations and are a key part of the sheet. I believe these are causing the issues. I hit this limit around 2600 rows, so I ended up temporarily eliminating one of the column formulas to maintain sheet function while I work towards a solution. Each of these formulas are supposed to calculate those sums for each unique "Email" entered (approx. 1000).
Total Hours Used for the current calendar year: =SUMIFS([Hours Used]:[Hours Used], [@Email]:[@Email], @cell = [@Email]@row, Date:Date, @cell <= Date@row, Date:Date, YEAR(@cell) = YEAR(Date@row))
Total Points for Last 365 days: =SUMIFS([Points Assigned]:[Points Assigned], [@Email]:[@Email], @cell = [@Email]@row, Date:Date, @cell >= TODAY(-365), Date:Date, @cell <= Date@row)
I hope that at some point SS can increase the limits on these sheets for larger scale applications, but that seems like a far off dream at this point.
