Can I create a drop down list that is auto-populated based on values from a column on another sheet?
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.
Help Article Resources
Check out the Formula Handbook template!