Formula cell limit

Options

tcanelli41471

tcanelli41471 ✭✭✭✭

04/25/18 edited 12/09/19 in Formulas and Functions

Help! I hit the 25000 cell limit when doing formulas .is there a work around or a way to get limit lifted with business license?

Tags:

0 ·

Comments

Mike Wilday ✭✭✭✭✭✭

04/25/18
Options
Can you archive some of that data by copying it to a new sheet? Maybe by year?

0 · Share on Facebook Share on Twitter
tcanelli41471 ✭✭✭✭

04/25/18
Options
Unfortunately no. I've already split the data into 4 tables. The issue is the number of columns and rows I need totals on.

0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Reference sheet CountIf Contains
Hello, I am trying to build a reference sheet that gives a summary of quarterly results. I need to count the row if the value contains either Exception or Samples. I tried many different versions only getting many different error messages. This is my last attempt getting a Invalid Operation. =COUNTIF({2023 Q4 Monitoring},…
Calculating Formula help
My goal is if total number of students is 0 then it should equal number of students then in Total students the formula will be total number of students minus number of students
IF OR Statement
Hi There! Looking for help to on an IF OR statement. Want to take two columns that will be either Yes or No, and populate another column with a date from two columns if it is Yes. Process, either the Facilitator or the Architect will be requesting a Complete By Date. Whichever requests, the other has to say yes or no. For…