Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here
Aug 13, 2020 01:40 PM
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!
Aug 13, 2020 02:03 PM
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.