Best Of

I am SO glad to see that this is on the roadmap!!
With the number of individual people to have to add to so many automations then remove if someone moves on, or add when we have new hires… The ability to just have groups to manage and keep updated that follow into automations would be incredibly helpful!
Cant wait until this feature is live for us!

I do something similar on a risk tracker I’ve built where I want to keep a record of the  initial values (doesn’t matter what) but also allow for it to be changed freely later. 

To do this create an automation that does a one time copy (eg when new row is added)  of the entire row to an identical helper sheet. 

Your original delivery date should be empty with a column formula which will look up the corresponding user inputted date column in the helper sheet. 

You can allow your users to change the date column as much as they want, as that date won’t be changed ever again in the helper sheet as it was a one time copy, therefore your original date will never change. 

You will need row to have a unique identifier to allow you to do the look up /index match or whatever you want. 

I use this method quite a lot for things like trends or anything that might change I want a record of an original baseline to compare it to.