Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

+1 year to date via automations

Topic Labels: Automations
406 1
Showing results for 
Search instead for 
Did you mean: 

Hi there, I have a database of social media campaigns with start dates and end dates. I’d like to have both dates add a year when the end date is older than yesterday (so once the campaign ends, it’s automatically set up to happen next year).

Ideally, I’d like it to happen once per month, but it can be any trigger. I should add that I’m on the free tier of Airtable

I’ve tried a few things, but I can’t seem to get the formula DATEADD({Start Date}, 1, 'years') to work with the automation. Any suggestions? image

1 Reply 1

Where are you putting the formula? You cannot use formulas directly in the automation itself. You need to put the formula in a formula field. Then the automation can read the value from the formula field and move the value to a different editable field.