Trying to create start and end dates for a task based on initial date field and duration being completed

I want the start date to be the initialized date of the task plus 1 day. The end date should be the start date plus whatever number is entered in the duration field.

I was trying to use IF plus DATEADD to first check if there was data in the initialized and duration fields, then proceed to auto fill the start and end field.

Any help is appreciated!

This really messes up a ton of people, but the most important thing to know about the formula field in Airtable is that it only supports straight quotes, not stylized quotes.

Note that your quotes are stylized.

Notice the extremely subtle difference between ’ and '

Hopefully someday, the Airtable team will improve the formula field to not choke on stylized quotes. But in the meantime, we have to be vigilant about spotting this ourselves.

2 Likes

This topic was automatically closed 15 days after the last reply. New replies are no longer allowed.