Is it possible to count a Blank Cell only text is filled out in another cell?
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!
Help Article Resources
Check out the Formula Handbook template!