How do I count number of sites in particular status if that site is not completed already.
Options
How do I count number of rows containing word "Completed" if not containing word "Completed" in another column?
This is what I am trying so far;
=COUNTIFS({Master Project Sheet Range 3}, "Completed", NOT({Master Project Sheet Range 2}, "Completed"))
Answers
-
David,
See below formula:
=COUNTIFS({Master Project Sheet Range 3}, "Completed", {Master Project Sheet Range 2},NOT(CONTAINS("Completed", @cell)))
The above checks if the other column contains the word completed (it may say other things as well...
If you want to check if it ="Completed" then use formula below:
=COUNTIFS({Master Project Sheet Range 3}, "Completed", {Master Project Sheet Range 2},NOT(@cell = "Completed"))
-
Great, Thanks that worked !
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!