How to count a value in a column based on the values of other two columns?
I'd like to know if there is a way I can count the status of the Tasks for an Area based if the Discipline and Quarter is a given value.
For example, I want to count how many "Completed" "Ongoing - On time", "Ongoing - Issue", "Active" and "Planned" there is in case of the other values are "Herb" and "23Q1"
So in this case I should be retrieving a value of 3 based on the first PI only (PI20001)
I've been trying some things but all retrieving error inputs...
I also made these Helper columns too (not sure if they are necessary for this, but anyways...)
Help Article Resources
Check out the Formula Handbook template!