I am not getting the result I need from a formula I am using. I am trying to track how many audits are completed and how many are left to do in total for this quarter '__ of ___ done', currently I am using this formula:
=COUNTIF(CHILDREN(Done2:Done130), 1) + " of " + COUNT(CHILDREN([Task Name]2:[Task Name]130)) + "" + " Done"
The hierarchy looks for example:
-Spring 2024
--Location
---Department
----Sub department (sometimes this doesn't exist)
Some sections have only a location and department and some have all three. I would like the formula to count the 'done' items -- for example it should count the the sub department not the department (if there is one), but currently it is counting everything (location , department, and sub department) making it look like we have 124 audits when we actually only have 100. Any help would be beneficial.