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.
Count Blank Cells
Hi
I am using Smartsheet for invoice approvals and would like to summarise how many documents are still awaiting approval.
I have tried using a countif formula to count all cells that are blank in a certain column, however I get results that include lines are not used, e.g. there are 10 documents entered on separate lines however there are another 40 completely blank lines and I get the result of 45 blank lines (40 blank lines and 5 that aren't approved). I just want the 5 counted.
(Those numbers are just examples, there will be more than 10 on the sheet)
Is there a workaround for this?
Thanks,
Emma
Comments
-
I would make all yellow rows children of row 1. Then you can use this:
=COUNT(CHILDREN($[PIR Number]$1)) - COUNT(CHILDREN($[Approval 1]$1))
-
Emma -
See if this gives you what you're after:
=COUNT([PIR Number]:[PIR Number]) - COUNT([Approval 1]:[Approval 1])
The COUNT function will count cells which are not blank, so this should give you the right answer.
Hope this helps,
John
-
Your solution works even without the hierarchy changes... COUNT will only include the non-blank rows.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.2K Get Help
- 414 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 141 Just for fun
- 58 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 299 Events
- 38 Webinars
- 7.3K Forum Archives