Can we use JOIN with an IF Statement

Options

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

Cierr Limited

Your Time is Important, you want to Stay on Track, We can help you use the Right Tools

https://www.cierr.com

Best Answer

  • Purnima Gore
    Purnima Gore ✭✭✭✭✭✭
    Answer ✓
    Options

    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

    Purnima Gore

    Cierr Limited

    Your Time is Important, you want to Stay on Track, We can help you use the Right Tools

    https://www.cierr.com

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!