Countif formula
Hi,
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?
Thanks,
Anne-Solene
Answers
-
The correct formula is =COUNTIF(Status:Status, @cell = "Not Started")
-
I'm glad you found a solution! Thanks for posting it. Let us know if you have any other questions for the Community.
Cheers,
Genevieve
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!