Count If Formula


Hi there,

I am trying to look up a WBS number from a cell in a column and count the number of times it appears in another column with the status of either "blocked", "work in progress" or "Not Started"

The first criteria seems to work (i.e. the bit that counts the blocked", "work in progress" or "Not Started"), but the second criteria fails. I want to link the 2nd criteria to a cell in a column which has a number.

Any pointers would be much appreciated.

Thanks in advance.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!