Skip to main content

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

Reply


Terms & Conditions