Using Control Center to update drop down lists on a regular basis
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?