Send Notification on New Value in Dropdown
I have a sheet with a dropdown list field where "Restrict to list values only" is off. Is there a way to set up a Workflow that always triggers when a value not currently in the list is entered?
I know you can create a condition for the field "where <field> is not one of" and select all of the current values but the workflow would need to be updated every time a new value is entered. I am looking for a way to set up the condition that would not require the workflow condition to be updated.
I plan to use Data Shuttle to keep the dropdown list options up to date.