Countif formula


I am building a formula to count the number of cells in a column that have a given value. =COUNTIF(Status:Status, "In Progress")

The cells in the Status columns have a vlookup formula. The countif formula does not work as it seems to not read the value of the cell but the formula. It was working before I added the formula. Any idea how to fix it?




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!