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
 10.7K Get Help
 63 Global Discussions
 69 Industry Talk
 385 Announcements
 3.5K Ideas & Feature Requests
 55 Brandfolder
 125 Just for fun
 50 Community Job Board
 464 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!