Automatically copy the dropdown list choices to other columns.
We use Smartsheet for the management of our timesheets. As in the same day, an employee can work on different projects, we have created several numbered columns allowing to associate hours in different cost center/projects. The type of column being Dropdown list, when we want to add a cost center or a project to the choice list, we have to do it manually in all the numbered columns one by one. Is it possible to somehow automate the choices available in the drop-down menu? Whether they come from a reference sheet or at least that the columns from 2 to 10 are automatically updated when column 1 is modified?