COUNTIFS based on Children criteria of certain row

Sandy Glassberg
Sandy Glassberg ✭✭✭
edited 01/16/20 in Formulas and Functions

Context: Please see screenshot attached. Project Manager "Fred" has 2 "active" projects in January: Project 1 and Project 2, which are Children under "Fred". This count of 2 is determined by some percentage of the project being completed.


Goal: Count the number of active projects per month based on % complete being greater than 0.


Request: Can someone please provide me with the appropriate COUNTIF formula based on these criteria? Thank you so much in advance!


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!