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!
Help Article Resources
Check out the Formula Handbook template!