Counting Blank Cells
I need assistance on counting all rows that are blank based upon a status column
The formula I used is: =COUNTIF({Status Blank}, HAS(@cell, "--")).
and I tried using this formula: =COUNTIF({Blank Status}), ISBLANK(@cell))
The "Status Blank" is referencing the other sheet.
Best Answer
-
If your cells are blank, then this should work:
=COUNTIF({Status Blank}, "")
However, this will also capture any blank rows (such as those at the bottom of your sheet, so I would use an alternative with another reference to your sheet where there will always be data if the row is to be used:
=COUNTIFS({Status Blank},"",{Other column}, <>"")
This will count the blank status where there is data in the other column but ignore any blank rows.
Hope this helps, but if you've any questions or problems then just post! 😊
Answers
-
If your cells are blank, then this should work:
=COUNTIF({Status Blank}, "")
However, this will also capture any blank rows (such as those at the bottom of your sheet, so I would use an alternative with another reference to your sheet where there will always be data if the row is to be used:
=COUNTIFS({Status Blank},"",{Other column}, <>"")
This will count the blank status where there is data in the other column but ignore any blank rows.
Hope this helps, but if you've any questions or problems then just post! 😊
-
Hi Brittanyy,
Please try the following formula, ‘Status blank’ is the range you are referring to from the other sheet, and “” is for finding all the blank cells in the range.
=COUNTIF({Status Blank}, "")
Thanks,
Kaveri Vipat
Senior Associate - Smartsheet Development, Ignatiuz Software
2023 Core Product Certified
Did this answer help you? Show some love by marking this answer as "Insightful💡" or "Awesome❤️" and "Vote Up⬆️"
-
Hi There SS Gurus!
I am having a similar issue. I have blank cells I would like to count however; the formula is returning #UNPARSEABLE
=COUNTIF([Assigned To]:[AssignedTo], "")
Nick Blocker - Analytics Adventurer
-
Hi @NickBlocker
I hope you're well and safe!
Try something like this.
=COUNTIF([Assigned To]:[Assigned To], "")
Did that work/help?
I hope that helps!
Have a fantastic week & Happy Holidays!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
@Andrée Starå - That worked! I have no idea what happened yesterday as that is the formula i was using but gave me the ##UNPARSEABLE however; this morning its working........
I appreciate your quick response and solution!
Nick Blocker - Analytics Adventurer
-
Excellent!
Happy to help!
✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.7K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!