Join(Collect - with IF statement

Jennifer Lenander

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.

Mark Cronk

I had a typo. Try:

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

Mark

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