Using Control Center to update drop down lists on a regular basis

Edward Sheaf

Does anyone have the need to run a regular (say once a week or once a month) global update to maintain dropdown lists on sheets that are in your template and pushed out to projects?

What I am talking about is the ability to have a "Recurring Global Update" set on a schedule to run each week, or month, that will update the options on a dropdown list in a sheet. I understand that there are data integrity issues with change dropdown options and not updating data held within the column that had been previously saved from a previous list of options that may have changed.

I think there may be an improvement gained through having this ability.

What does everyone think?

Andrée Starå

Hi @Edward Sheaf

I hope you're well and safe!

Great idea! That would be a great addition to Smartsheet features.

Please submit this as a Product Feedback or Idea (If it hasn't been added already) when you have a moment.

Here's a possible workaround or workarounds

• Using Premium App, Data Shuttle

Is that an option?

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 support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Edward Sheaf

Hi @Andrée Starå ,

I have added an enhancement around this suggestion as I think it would improvement the CC functionality.

With using data shuttle as you suggested, it would require a separate data shuttle workflow for each CC project created and these would then need to be managed manually if a change occurred. For 200+ projects this is not feasible. Thanks for the suggestion though.

Cheers,

Ed