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
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!