25,000 cross-sheet references limit

Kirstine ✭✭✭✭✭✭
edited 12/09/19 in Formulas and Functions

I use a lot of cross references in my sheets. In one sheet, my blue arrow references have got the error code #CALCULATING on them which I know is because I must have gone over the 25,000 limit. I've archived about half the rows though and I'm still getting the same error. What am I getting wrong...? :(



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!