How to get all drop down values to pop up in one cell?
Answers
-
Hi @triveintern
You can pull the attendee names to the parent row (the row with "Attendees") and then use the same formula to get the value against the first row (the row with "ACG DealFest Northeast"). The formula you can use is =JOIN(CHILDREN(), " , "). You can change the delimited from comma in this case to any other symbol as well.
I am not sure how you're capturing attendee names in this sheet. But if you want the value to appear only when 100% is marked in another column, you should capture the name in a different column and use a formula to bring it to the attendee name column when 100% is marked.
Thanks,
Aravind GP| Principal Consultant
Atturra Data & Integration
M: +61493337445
E:Aravind.GP@atturra.com
W: www.atturra.com
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!