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

Alex Hackford

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.

Mark Cronk

Hi @Alex Hackford ,

Unfortunately, you can't populate a drop down from another list. Dynamic dropdowns sounds like a great suggestion though. You can submit it as an enhancement idea using the link below.

https://app.smartsheet.com/b/form/739aa75f30ca43a8a22eb53e4da7d409?ss_v=112.0.1

Mark

Mark Cronk

Hi @Alex Hackford ,

Unfortunately, you can't populate a drop down from another list. Dynamic dropdowns sounds like a great suggestion though. You can submit it as an enhancement idea using the link below.

https://app.smartsheet.com/b/form/739aa75f30ca43a8a22eb53e4da7d409?ss_v=112.0.1

Mark

Lynette.Smith

You can use a 3rd part tool called ddup. It is actually reasonable priced and easy to setup. I use it and it works great. I website is ddupdate.com.

LRO

@Lynette.Smith,

I'm curious if you have reached out to DDUPDATE.com to ask what information they can provide to ensure security with their app? I want to use this for my PMO but am reluctant to because of security reasons.

liz.mayeux

i recently learned to use the data shuttle offload and then upload function for the drop down list to be populated from sheet to another