Join/Collect? Formula to record text in a row on if a box is checked on sheet one ...

I am trying to put a formula on Sheet 1 in Column 2 that references Sheet 2, column 2 (DBE)( checkbox) - if the box is checked on Sheet 2, The text from Column 1 (Vendor) will all populate with a comma between each on Column 2 on Sheet 1
SHEET 1
SHEET 2
Thank you! I'm stumped on this one!
Best Answer
-
Ok. In that case you would use something along the lines of
=JOIN(COLLECT({Column To Join}, {Checkbox Column}, @cell = 1), ", ")
Answers
-
Are you able to manually enter the outcome you are hoping to achieve and provide a screenshot of that?
-
Sure!
SHEET1 Column 2
Sheet 2 Column 1 Column 2
-
Ok. In that case you would use something along the lines of
=JOIN(COLLECT({Column To Join}, {Checkbox Column}, @cell = 1), ", ")
-
Bingo! I had missed a "
Thank you so much!!
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 431 Global Discussions
- 152 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 74 Community Job Board
- 501 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!