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?
How to populate a date field using automations
+17Hi @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
Login to the community
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.