Is it possible to count a Blank Cell only text is filled out in another cell?

Jeffrey H
Jeffrey H
edited 12/09/19 in Formulas and Functions

Currently I'm using this formula =COUNTIF(Status:Status, "") to summarize all the blank cells in the Status column. 

 

The issue is that it also counts the Status cells that are just blank rows at the bottom of the sheet.  Is there a way to count only the blank Status cells if there is also information populated in the Activities column?  

 

Thank you Smartsheet community! 

2018-12-05.png

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!