Linking sheets through dropdown box

Beryl, As Atus pointed out, there is not a built in way to link a Dropdown List to a column in another sheet but this is possible with a third party app - Azuqua. 

You mentioned you want to have new staff members automatically added to your Dropdown Lists so they can select their names.  Have you considered using Contact List columns instead? 

Contact lists will auto-resolve user's names based on, who is assigned to tasks in the sheet, who is shared to the sheet, who is in your Smartsheet Contacts, and who is a member of your team.

If you add the new staff member to your team, then they will just need to start typing their name in the Contact List cell and Smartsheet will auto-resolve their information. 

You can then use the Contact List for things like Resource Management, Reporting, and Reminders. 

Knowing that Azuqua can do it, I'm still requesting (or vote for) the ability, directly in Smartsheet, to create dropdown lists dynamically from a column on a different sheet. Furthermore, I wish for this ability to have a filter. For example, in my timesheet, the Project column is a Dropdown list of all projects (from my master projects sheet) that have a Status of "Open".

Without having to re-create filters directly functionality when you define the dropdown, you could just add the ability to use an existing filter from the "master" sheet.

Without filters, this ability is still useful, though not as much. So please consider filters as well when you consider this functionality.

Think so.  It looks quite achievable with the API and I will try to develop a solution myself.  If I am successful I'll share it with you.

Travis, 

I built www.ddupdate.com to do exactly this. 

Have you checked it out?

-J

Apparenlty, very unfortunate 

Jack, 

Dropdown options are assigned on the column level. To create dropdown options based on the selection of a prior option, this would require being able to set the options on the row level, which is not supported by the API. 

-J