How do I do a COUNTIFS for a Department if the CHILD cell is either "Green" or Blank?

I'm trying to count each Active project that is below a Department that's Budget is either Green or Blank.

In the example below, for Department 4, the Budget count should be 4 not 2.

I'm using this formula =COUNTIFS(CHILDREN([Initiative Stage]@row), "Active", CHILDREN(Budget@row), "Green") but have had no luck with the variations of the OR formula.

Thank you

Best Answer

  • Sameer Karkhanis
    Sameer Karkhanis ✭✭✭✭✭✭
    Answer ✓

    You are only checking if the children are Green so it is obvious that it will count only those that are green. For the ones which are blank you need to add that as an OR condition as below,

    COUNTIFS(...........CHILDREN(Budget@row), OR(@cell="Green", @cell=""))


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!