CountIFs using multiple criteria


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!



Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!