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!!!

Find more posts tagged with

Accepted answers

All comments

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?

Kelly

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.