Display multiple selections in another column.

Options
This discussion was created from comments split from: Add multiple amounts together for multiple selections.

Answers

  • Arianna Sikorski
    Options

    I have an additional question to this formula. I want to use the same formula, but instead of adding number amounts, I want it to display multiple selections in another column.


    Currently, tried this: =IF(CONTAINS("- Joining neighborhood-based, in-person adult learning house parties", [22/23: Torah (Learning) Commitment]@row), "Jewish Journey") + IF(CONTAINS("- Participating in holiday themed classes in preparation for upcoming Jewish holidays", [22/23: Torah (Learning) Commitment]@row), "Holiday Bootcamp")


    Which it did work to display both short term options in the next column, but it is adding them together so there is no space and they aren't showing up as separate options. When exporting answers to Excel, I need these different terms to export as separate selections, not one answer. Right now, I manually select these short terms to match what was submitted. So with the current formula, it displays "Jewish JourneyHoliday Bootcamp" as one answer. But I want the formula to separate them out as separate answers if they are selected. The column the formula is in is a multi-select option. Is there a way to have the formula display multiple options selected so I don't have to manually select?

  • Darren Mullen
    Darren Mullen ✭✭✭✭✭✭
    Options

    @Arianna Sikorski If you add a carriage return after each selection, that should work.

    Try the following formula. Notice I added CHAR(10) which adds in the carriage return to create a new selection.

    Currently, tried this: =IF(CONTAINS("- Joining neighborhood-based, in-person adult learning house parties", [22/23: Torah (Learning) Commitment]@row), "Jewish Journey"+CHAR(10)) + IF(CONTAINS("- Participating in holiday themed classes in preparation for upcoming Jewish holidays", [22/23: Torah (Learning) Commitment]@row), "Holiday Bootcamp"+CHAR(10))

  • Arianna Sikorski
    Options

    @Darren Mullen Thank you! That CHAR(10) separated the terms the way I needed, however, the formula puts a "0" at the beginning of a term name if there is only one selected or on the last term of multiple selections.

    So if only one is selected, it looks like "0Holiday Camp". If it's multiple, it looks like "Holiday Camp Jewish Journey 0Prayer/Parsha Study"

    I tried putting a space at the end of the formula, but nothing changes. Is there a way to tell it not to include the zero since it's "adding" terms? Here is the current formula I am using:


    =IF(CONTAINS("- Learning in preparation for a lifecycle event (converting, adult Bnei Mitzvah, wedding, etc.)", [22/23: Torah (Learning) Commitment]@row), "Jewish Journey" + CHAR(10)) + IF(CONTAINS("- Participating in holiday themed classes in preparation for upcoming Jewish holidays", [22/23: Torah (Learning) Commitment]@row), "Holiday Bootcamp" + CHAR(10)) + IF(CONTAINS("- Participating in our online classes (e.g. Parsha Study (The Weekly Torah Reading), The Hows and Whys of Jewish Prayer)", [22/23: Torah (Learning) Commitment]@row), "Prayer/Parsha Study" + CHAR(10)) + IF(CONTAINS("- Participating in Family and/or Parent Learning", [22/23: Torah (Learning) Commitment]@row), "Family and Children's Programming" + CHAR(10)) + IF(CONTAINS("- Joining weekday Morning Minyan services on Zoom", [22/23: Torah (Learning) Commitment]@row), "Morning Minyan" + CHAR(10)) + IF(CONTAINS("- Joining neighborhood-based, in-person adult learning house parties", [22/23: Torah (Learning) Commitment]@row), "Adult Learning" + CHAR(10)) + IF(CONTAINS("- Participating in cohort-based learning series (by demographic or about particular themes)", [22/23: Torah (Learning) Commitment]@row), "Cohort Learning" + CHAR(10)) + " "

  • Darren Mullen
    Darren Mullen ✭✭✭✭✭✭
    Options

    @Arianna Sikorski That's interesting behavior.... It's not apparent to me why it's doing that. I'm not able to replicate that result with a simple formula in one of my sheets.

    You could try using the same formula in another column and see if you can eliminate the part of the formula that is causing it?

  • Arianna Sikorski
    Options

    @Darren Mullen would prepopulated selections be the cause? When I change the formula to work in the entire column, any rows of information that are already there have the "0." When I submit a new row of information, it looks like the zero only shows at the end of multiple selections, the single selections come out fine without the zero.

  • Darren Mullen
    Darren Mullen ✭✭✭✭✭✭
    Options

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!