Count empty rows adjacent to a column that includes a specific selection.


I am trying to count the number of empty rows in the PM Action Description column adjacent to the ImprovementComments column where only the Actionable Comments is selected.

Can someone help with the formula to do this. I don't know where to start.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!