Collect drop-down value used in a column

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.

Best Answer


  • Roy Yue
    Roy Yue ✭✭✭

    Are you a genius? 😍😍

    Thank you!

  • Genevieve P.
    Genevieve P. Employee Admin

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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!