Collect dropdown value used in a column
I am looking for a function to collect dropdown value used in a column, and saved in a cell.
For example, on "Types" column, it has "Type A""Type B" as a list, whatever the list value used in each row, I want to store used ones in the first row.
Best Answer

Hi Roy,
If I'm understanding you correctly, you have a column with multiple options to select, and this column may have the same option selected more than once. However, you want one summary cell that returns each of the Types selected, once.
Like this?
If so, I you can build an IF(HAS statement for each Type, which would return the name of the Type if it's present in the column. Then you can add all these IF statements together. You'll notice I added + " " to add in a space between the types, as well.
=IF(HAS(Types:Types, "Type A"), "Type A") + " " + IF(HAS(Types:Types, "Type B"), "Type B") + " " + IF(HAS(Types:Types, "Type C"), "Type C")... etc
I input this formula in a column next to it so that I could easily reference the entire column by writing Types:Types. If you want to have this formula in the same column, you will need to adjust the reference to have a startrow and an endrow, such as the following: Types11:Types35
Here are some Help Center articles I used: IF function / Joining Text in Formulas / HAS function / Column References in formulas
Let me know if this works for you!
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8  10, Seattle, WA  Register now
Answers

Hi Roy,
If I'm understanding you correctly, you have a column with multiple options to select, and this column may have the same option selected more than once. However, you want one summary cell that returns each of the Types selected, once.
Like this?
If so, I you can build an IF(HAS statement for each Type, which would return the name of the Type if it's present in the column. Then you can add all these IF statements together. You'll notice I added + " " to add in a space between the types, as well.
=IF(HAS(Types:Types, "Type A"), "Type A") + " " + IF(HAS(Types:Types, "Type B"), "Type B") + " " + IF(HAS(Types:Types, "Type C"), "Type C")... etc
I input this formula in a column next to it so that I could easily reference the entire column by writing Types:Types. If you want to have this formula in the same column, you will need to adjust the reference to have a startrow and an endrow, such as the following: Types11:Types35
Here are some Help Center articles I used: IF function / Joining Text in Formulas / HAS function / Column References in formulas
Let me know if this works for you!
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8  10, Seattle, WA  Register now 
Are you a genius? 😍😍
Thank you!

Haha! You're welcome  glad that it worked for you. 🙂
Join us at Smartsheet ENGAGE 2024 🎉
October 8  10, Seattle, WA  Register now
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 61.3K Get Help
 321 Global Discussions
 197 Industry Talk
 417 Announcements
 4.2K Ideas & Feature Requests
 126 Brandfolder
 153 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!