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

Emma
Emma
edited 04/13/17 in Archived 2017 Posts

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

 

 

Screen Shot 2017-04-13 at 21.07.35.png

Screen Shot 2017-04-13 at 21.12.55.png

Screen Shot 2017-04-13 at 21.15.09.png

Screen Shot 2017-04-13 at 21.07.35.png

Screen Shot 2017-04-13 at 21.12.55.png

Screen Shot 2017-04-13 at 21.15.09.png

Screen Shot 2017-04-13 at 21.07.35.png

Screen Shot 2017-04-13 at 21.12.55.png

Screen Shot 2017-04-13 at 21.15.09.png

Screen Shot 2017-04-13 at 21.07.35.png

Screen Shot 2017-04-13 at 21.12.55.png

Screen Shot 2017-04-13 at 21.15.09.png

Comments

This discussion has been closed.