COUNTIFS with an OR in it

Hi Community!

I am struggling with the below COUNTIFS formula which basically has to have an OR logic in it...

=IF(Date@row <= TODAY(), COUNTIFS(OR({Status 1}, "Complete", {Status 11}, "N/A"), {Planned End Date 1}, <=Date@row, {Parent Child 1}, "Child"), "")

There must be a syntax error, but I can't find it. Any hints or tips would be great!

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

Can you describe the expected logic?

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.