Set one or many dropdown lists to automatically update from a master source. When the master source changes, all the dropdowns lists in sheets that been configured will also update automatically, usually within 2 minutes.
You can set as many columns as you wish to be updated from one single source, and set up as many separate configurations as you need.
And coming soon, you will be able to use other data sources to update your dropdowns in Smartsheet.