JOIN COLLECT IF Statement

Hello Team,

I have the below formuale which works just fine. However, I need to add a condition to this wherein it only picks those 'Program Status' which are 'Active'

How do I add the IF Statement to the current string.

=JOIN(COLLECT({Program Name}, {Project Health}, [Red Status]1), ", ")

Thanks.

Find more posts tagged with

Accepted answers

All comments

Hollie Green

The below should work just added an additional criteria range and criteria to the collect formula. You will have to create the cross reference for the Program status.

=JOIN(COLLECT({Program Name}, {Project Health}, [Red Status]1,{Program Status},"Active"), ", ")

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.