Dynamically Update Column Properties?
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.