Custom Column Dropdown list from another sheet

I am trying to have my list of dropdown items in a column update based on another sheet in smartsheets. Basically would like to have the dropdown values change when the values in the other smartsheet sheet updates.

The list would be current projects we have going on at the time and as we win more projects this list would obviously change.


Does anyone know how to do this?


Thanks!

Answers