Hi. I’ve set up a few automations with no problems, but I am not sure how to do this one… or if it can be done.
I have an AutoDate column, so when a form entry comes in, it auto-dates the entry of the form. However, I need to then copy that date over to another column (also called Date). That second column, called Date, is used in another formula in the sheet, and I need to be able to edit it (in a way I cannot edit the AutoDate column). But since they are the same 95% of the time, it would save me time if it could auto-populate.
So, in short, how can I automate copying date from the Auto-Date field to the Date field? Is this possible?