Automation with variable date field

[Bruno_Loreto]

I want to set an automation that duplicates a record every time the original record is updated to status DONE.

But I’m finding trouble.

How could I set for TOMORROW the DATE FIELD of the new record created by the automation?

[ScottWorld · Accepted solution]

Unfortunately, automations don’t allow you to write formulas, so you would need to create a formula field in your table that equals tomorrow. (You can hide this formula field after you create it.) Then you can call upon this field in your automation.