Join(Collect - with IF statement

My Join(Collect statement works on its own but when I try to add the IF statement I get an "Invalid Operation."

=IF({NewDeployment} = "1", JOIN(COLLECT({Station2}, {Month}, "1", {Year}, "2020"), ", "))

My "New Deployment" column is a checkbox column and I only want to join/collect the names of the stations where "New Deployment" is checked. Not sure where my formula is wrong.

Find more posts tagged with

Accepted answers

Mark Cronk

I had a typo. Try:

=JOIN(COLLECT({Station2}, {Month}, 1, {Year}, 2020, {NewDeployment}, 1), ", ")

Mark

All comments

Mark Cronk

Hi Jennifer,

Does this get you what you're looking for:

=JOIN(COLLECT({Station2}, {Month}, 1, {Year}, 2020), {NewDeployment}, 1), ", ")

Mark

Jennifer Lenander

Unfortunately no, it returns #Unparseable

Mark Cronk

I had a typo. Try:

=JOIN(COLLECT({Station2}, {Month}, 1, {Year}, 2020, {NewDeployment}, 1), ", ")

Mark

Jennifer Lenander

Per usual, @Mark Cronk to the rescue!

Mark Cronk

Always happy to help. Thank you for using the Community.

Be Well,

Mark

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.