I have a Sharepoint library where I receive folders via email. I have a calculated column that determines the week ending date (as a string value) for the folder and I want to create a choice column that inherits these dates so it can be used for metadata navigation.
Question is: can I create a workflow that updates the choice column when a new folder is added with a new week ending date?