I am setting up a fairly simple Task list. I have a field called 'Recurring' which can be 'Yes' or 'No'. I set up an automation that will duplicate the record (if recurring = yes) when the 'Status' field is changed to 'Closed'.

For almost all fields, I simply want to copy the values from the existing record into the new record. That works fine. However, for the 'Due Date' field, I want to calculate a new date based on the existing date field. However, exact copying is all that's available.

Can we get calculations for fields in automation-created records?