How to populate a date field using automations

So I’m wanting to populate a date field with a date 60 days in the future, whenever another date field is updated.
Example:
In a CRM, I enter ‘latest call date’ field as today, I want it to automatically populate "next call due’ date field with a date 60 days in the future.
Any tips?

Hi @alex_bray

Welcome back to Airtable Community!

You first need a formula field like this

DATEADD({Date Field}, 60, 'days')

If you dont want it to be a formula field for any reason, then you can use this formula field to update the other date field using an automation

1 Like