Using automation to update a date field
I know you can use the record a date automation to record the current date in a field, but is there any way to update a date field to a chosen value?
We have a date field for the finishing of a task - date finished. If the user selects a Release value from an other drop down column, we want the date finished field to automatically update with the date corresponding to that release. If the release is not selected, then the user can enter whatever date they choose.
We have the Release drop down, which uses a VLOOKUP to populate a helper column called Release Date
We want to create automation that says "When the ER column is changed, change the Date Finished to the Release Date"
That way, if the user selects an ER, then the Date Finished is automatically populated. If not, they can enter their own date.
However, Smartsheet will not let you update a date column with anything except today's date.
Has anybody devised a work around?