Dynamically Update Column Properties?

GregJames

Hi there,

Have been searching for a way to resolve this before posting but with no luck so far. I want to know if its possible to update the column properties based on a specific set of values from a lookup table? The column properties related to 'Workstreams' which are often updated and added to, and its currently a manual task to update the properties. What I am looking for is a way to use a master table as the source to update the single / multi-select option in the column and allow the table to be the single source of data that drives the sheet options.

The mater table will also be used to populate reports and therefore will always be in sync with one another.

Thank you!

Genevieve P.

Hi @GregJames

There isn't a way to do this directly within Smartsheet, but you can update dropdowns if you have access to the premium add-on Data Uploader (see here).

If I've misunderstood what you're looking to do, it would be helpful to see a screen capture of your sheet and the columns you're looking to update!

Cheers,

Genevieve