Collect drop-down value used in a column

Roy Yue

I am looking for a function to collect drop-down 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.

Genevieve P.

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 start-row and an end-row, 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

Genevieve P.

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 start-row and an end-row, 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

Roy Yue

Are you a genius? 😍😍

Thank you!

Genevieve P.

Haha! You're welcome - glad that it worked for you. 🙂