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 = ""))
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 210 Industry Talk
- 441 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 300 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!