Combine JOIN(COLLECT) and IF(AND)
I am trying to return specific text based on check boxes and want it to list if true.
Apples Apples 1Apples 2Apples 3 Apples 4Apples 5 Apples 6 and so on...
I have check boxes under each Apples column where people can select which Apple they want.
In the Apples column I want to return a list of their selections like this:
Apples 1
Apples 3
Apples 6
Right now I have two formulas and I'm able to return the list and the selection separately but I want to combine to get the above result. Here is what I have:
Formula 1: =JOIN(COLLECT([Apples 1]@row:[Apples 10]@row, [Apples 1]@row:[Apples 10]@row, =1), CHAR(10))
Formula 2: =IF([Apples 1]@row = 1, "Apples 1", IF([Apples 2]@row = 1, "Apples 2", ""))
Thank you!!
Best Answer

You would have to "add" multiple IF statements together instead of nesting them.
=IF([Apples 1]@row = 1, "Apples 1" + CHAR(10), "") + IF([Apples 2]@row = 1, "Apples 2" + CHAR(10), "") + .................
Answers

You would have to "add" multiple IF statements together instead of nesting them.
=IF([Apples 1]@row = 1, "Apples 1" + CHAR(10), "") + IF([Apples 2]@row = 1, "Apples 2" + CHAR(10), "") + .................

Thank you! This worked perfectly!

Happy to help. 👍️
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 61.3K Get Help
 321 Global Discussions
 197 Industry Talk
 418 Announcements
 4.2K Ideas & Feature Requests
 127 Brandfolder
 154 Just for fun
 124 Community Job Board
 441 Show & Tell
 26 Member Spotlight
 1 SmartStories
 278 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!