# Is the a formulas that counts cells? Sheet limit question

✭✭✭✭

Hi, I was wondering if there a formula that can count the number of cells in a sheet? I'm trying to make sure we don't go over Smartsheet limits. Also do the sheet limits count all cells in a row or only those cell with information in them?

Thank you

Kim

Tags:

• ✭✭✭✭✭✭

It depends on which limit you are wanting to calculate for, but the general rule of thumb is that all cells will be counted in a row that has been used regardless of whether or not the cell is blank.

• Employee

Hello @Kimbh,

Please note the sheet component maximum:

Rows: 20,000

Columns: 400

Cells: 500,000

Characters in a cell: 4,000

Unique cells referenced in cross-sheet formulas: 100,000

To determine how close you are to the 500,000 cell limit, multiply the number of columns in your sheet by the number of rows. For example, a sheet with 20,000 rows can only have 25 or fewer columns, and a sheet with 400 columns can only have 1,250 or fewer rows.

Cheers,

Marcela.

October 8 - 10, Seattle, WA | Register now

• ✭✭✭✭✭✭
edited 10/10/23

Hi @Kimbh

I use the Sheet Summary fields to count columns and rows and then multiply them to get total cell count.

TtlColumns: =COUNT([ColA]1:[ColZ]1) + COUNTIF([ColA]1:[ColZ]1, "") + 1

TtlRows: =COUNT([ColA]:[ColA]) + COUNTIF([ColA]:[ColA], "")

TotalCells: =TtlColumns# * TtlRows#

(Replace ColA and ColZ with your first and last column names)

In a new, blank first row, use an existing column to reference the TotalCells# field from the Summary pane AND have specific text (TOTAL CELL COUNT) in another column to use as a condition for automation. (I color this row orange.)

Automation notifies me when that number is greater than 350,000 and the other column contains the specific text.

When I reach the limit I delete rows. If we need to retain the info, I'll create a new sheet from the existing and then delete the data on the existing sheet. My example is an archive sheet that has rows automatically moved to it.

Hope this helps!

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!