CountIFs using multiple criteria

Options

I want a count of the number of tasks that are complete. I don't want to include anything marked as not applicable or any headings (Hierarchy=Grandparent or parent), and it is counted as complete whether it completed by Medhost or by facility.

=COUNTIFS([Not Applicable]:[Not Applicable], 0, Hierarchy:Hierarchy, "Child", OR([Completed by MEDHOST]:[Completed by MEDHOST], 1, [Completed by Facility]:[Completed by Facility], 1))

The above formula is giving me "Invalid data type".

thank you in advance!

Jennifer

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!