% Complete Based on Child Conditions Met
Options
Answers
-
Did you figure this one out? I'm looking to do the same thing, only counting the % passed of anything that is not blank:
-
@R Oatis Try something like this:
=ROUND((COUNTIFS(CHILDREN(), @cell = "Pass") / COUNTIFS(CHILDREN(), @cell <> "")) * 100) + "%"
-
Where do I Add The OR Function to add another Status Such as Failed? Here is what I tried but Unsuccessful:
=ROUND((COUNTIFS(CHILDREN(), OR(@cell = "Pass", @cell = "Fail") / COUNTIFS(CHILDREN(), @cell <> "")) * 100) + "%")
-
Resolved The Or Issue. I was Missing a Parenthesis
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!