Can I create a drop down list that is auto-populated based on values from a column on another sheet?

Alex Hackford
Alex Hackford ✭✭✭
edited 12/22/20 in Formulas and Functions

I would like to create a drop-down menu column on one sheet with values that are auto-populated based on the values in the 'event name' column on another sheet. The goal would be that when a new row is added to the 'event name' column on sheet 2, the drop down on sheet 1 then includes that new row value.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!