Display multiple selections in another column.
Answers
-
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?
-
@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))
Darren Mullen, smartsheetguru.com
Get my 7 Smartsheet tips here
Author of: Smartsheet Architecture Solutions
-
@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)) + " "
-
@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?
Darren Mullen, smartsheetguru.com
Get my 7 Smartsheet tips here
Author of: Smartsheet Architecture Solutions
-
@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.
-
@Arianna Sikorski I'm not aware of why that would matter.
Darren Mullen, smartsheetguru.com
Get my 7 Smartsheet tips here
Author of: Smartsheet Architecture Solutions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!