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...)
Thanks!!!
Answers

Hey @Flavio Tincani
ITry this. You can place formula in one of your helper columns  you do not need either one of them.
=IF(COUNT(CHILDREN()) > 0, COUNTIFS(CHILDREN(Discipline@row), Discipline@row, CHILDREN(Quarter@row), Quarter@row) + 1)
Since this formula only counts the Child rows, I had to add the +1 at the end to include the [Area] of the Parent Row
Will this work for you?
Kelly
Help Article Resources
Categories
Check out the Formula Handbook template!