How do I count how many columns are in another smartsheet?
I've ran into issues with cell limits, so now I am trying to create a summary sheet of all of my smartsheets that would calculate how many columns are used in each smartsheet.
I've tried adding a [First Column] and [Last Column] in the actual smartsheet I want to count, then used this formula:
=COUNTIFS([First Column]1:[Last Column]1, OR(NOT(ISBLANK(@cell)), ISBLANK(@cell)))
This worked within the actual smartsheet. But I want these counts in a seperate smartsheet and can't figure out the formula syntax to use. I've tried this:
=COUNTIFS({Exam Practice Sheet Range 1}, OR(NOT(ISBLANK("")), ISBLANK(<>"")))
This returns "Invalid Operation"
Any suggestions
Answers

Assuming {Range} is a row selection, you will need "@cell" references in your formula:
=COUNTIFS({Exam Practice Sheet Range 1}, OR(NOT(ISBLANK(@cell)), ISBLANK(@cell)))
But my personal choice is to do away with the NOT and ISBLANK functions entirely because I hate dealing with parenthesis any more than is absolutely required.=COUNTIFS({Exam Practice Sheet Range 1}, OR(@cell <> "", @cell = ""))
Help Article Resources
Categories
Check out the Formula Handbook template!