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...)



  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭

    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?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!