Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Incorrect Counting of Empty Rows
I am trying to count blank dropdown values in a sheet by referencing the column and it is giving me incorrect numbers.
=COUNTIF([Sign Off]:[Sign Off], 0)
It seems to be including the 10 empty rows at the bottom of the sheet too.
Does anyone know how to get around this?
Comments
-
Hello,
Â
Thanks for the question. Since the blank rows at the bottom of the sheet are technically blank for that column, counting blank cells in that column will add them to the count. As a way to get around this, you could change your formula to the COUNTIFS function, and use another column that should always have information in it for the rows you'd like to count.
Â
For example, if the Primary Column has information in it for every row except the blank ones at the bottom, something like this could work:
Â
=COUNTIFS([Sign Off]:[Sign Off], ="", [Primary Column]:[Primary Column], <>"")
Â
The ="" means equals blank, and the <>"" means doesn't equal blank. So this formula will count rows that the "Sign Off" column is blank, but only if the "Primary Column" isn't blank.Â
-
Thanks so much. That works!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 209 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
- 298 Events
- 33 Webinars
- 7.3K Forum Archives