Skip to main content

Hello! 

We were previously using this formula to calculate a recurring date in the future: 

DATEADD("Publish Date", 7, "days") 
 
However, we're now getting an #Error Message in our base. 
 
I did some searching and found this blog from Airtable. 
 
I tried using their exact formula in that blog as:
DATEADD({Publish Date},7,‘days’) but it is telling me "Sorry there was a problem saving this field. Invalid formula. Please check your formula text" 
 
Can anyone help me with what the correct formula is now? I am so lost....


The formula works as described.  I would delete the formula field and recreate it.  If you can't delete it, create a new one and type in the formula to verify it works. 

@Kristen_Waggene

The problem is the curly quotation marks. Airtable’s formula field can only accept straight quotation marks, not curly quotation marks.

As @Dan_Montoya mentioned above, retyping the formula will solve it… or just retype the quotation marks.

Thank you both for your input! @Dan_Montoya and @ScottWorld! I went in to try your suggestions this morning, and it magically fixed itself without me touching it today, so it appears there may have been some sort of bug in our base temporarily.  

Reply


Terms & Conditions