Automatically copy the dropdown list choices to other columns.

Julie Barbeau

Hello,

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?

Andrée Starå

Hi Julie,

A solution that would be perfect for this use-case is the premium add-on, Data Uploader.

Is that an option?

More info: 

https://www.smartsheet.com/marketplace/premium-apps/data-uploader

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Julie Barbeau

Hi Andrée,

Unfortunately not, too expensive. Any other idea?

Andrée Starå

@Julie Barbeau

It's possible with the Smartsheet API, and there are some 3rd party options that are built with the API.

Would the Smartsheet API be an option?

Julie Barbeau

What is the Smartsheet API?

Andrée Starå

@Julie Barbeau

Have a look here.

https://developers.smartsheet.com/