Skip to main content

Hi there, I want to update date field by adding some days to it with formula DATEADD when status changed on another field. New value for the field where I want to update like this:


DATEADD({ValidDate}, {DaysToAdd}, ‘days’)


But when I click to Run Test then always appears test failed message:


Test failed: Received invalid inputs.


Anybody know how to fix it?


Thanks in advance.


Hi @Soporboy and welcome to the community!


Unfortunately, Airtable’s automations don’t support formulas at this time, so you’ll have to use a workaround for this (creating formula in your base and then add the field to your ValidDate field in the automation).

Reply


Terms & Conditions