Countifs only if its a parent row

Hi guys, running into a dilemma where im trying create a countifs for a dashboard for statuses, but I only want the main status from the parent columns and not the tasks. Screenshot shows the status field has multiple in the status "Draft".

I'm not super familiar with the children/parent fomula and could use a little help!

Skip WBS that is checkmarked will serve as the indicator that the line is the parent.

Thank you all

Find more posts tagged with

Countif

parent row

Accepted answers

Paul Newcome

You would use a COUNTIFS to include multiple range/criteria sets.

=COUNTIFS({Status Column}, @cell = "Status", {Checkbox Column}, @cell = 1)

All comments

Paul Newcome

You would use a COUNTIFS to include multiple range/criteria sets.

=COUNTIFS({Status Column}, @cell = "Status", {Checkbox Column}, @cell = 1)

AndrewT

Thanks paul this worked great for me!

Paul Newcome

Happy to help. 👍️

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.