Can we use JOIN with an IF Statement

Purnima Gore

Hi

The scenario is

I run a meeting with tasks for an agenda item and we have a list of them.

Each task has a reference to the Agenda Item.

eg.

Agenda Item 1 - Action 1 - update plan

Agenda Item 1 - Action 2 - distribute plan

Agenda Item 2 - Action 1 - create resourcing requirements

Agenda Item 2 - Action 2 - provide marketing materials

What I would like to achieve in the summary field is

If Action Items are related to Agenda Item 1, then join them together

So the result would be

Update Plan, Distribute Plan

I tried the If (logical expression, true value (Join(Column:Column,","), but that isn't working.

I can then pull this data into a single cell in another sheet along and put all the items in a cell to generate a document.

Any ideas? :-)

Thanks

Purnima

Purnima Gore

Hi @Michael Culley

Just a slight adjustment and it worked.

=JOIN(COLLECT([Action Item]:[Action Item], [Agenda Item]:[Agenda Item], "1"), ",")

Thanks for the suggestion above. got my brain thinking in another way :-)

PG

Michael Culley

What about something like this?

=JOIN(COLLECT([Action Item Column]:[Action Item Column], [Agenda Column]:[Agenda Column], CONTAINS("Agenda Item 1", @cell)), ", ")

Does that get you started in the right direction?

Purnima Gore

Hey @Michael Culley - doesn't give me an error at least :-) but only seeing a blank cell.

Thanks for that. I never thought about using "COLLECT" within the JOIN statement as I tried "COLLECT" Outside.

Something to work on though. Appreciated. PG

Michael Culley

Could you send a screenshot of your sheet? I think that would help alot.

Purnima Gore

Hi @Michael Culley

Just a slight adjustment and it worked.

=JOIN(COLLECT([Action Item]:[Action Item], [Agenda Item]:[Agenda Item], "1"), ",")

Thanks for the suggestion above. got my brain thinking in another way :-)

PG

Michael Culley

@Purnima Gore Awesome!

Michael Culley