Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Formulas and dates

Topic Labels: Formulas
399 1
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi wonder if there is anyone who can help. I am trying to make a deadline field. I need a formula that adds a certain amount of time to the created date if another field has a certain word in it.
hope this makes sense

1 Reply 1

Hi @richard_snell - try this (adds 10 days):

IF(
  {Your word field} = 'Your special word',
  DATEADD({Date}, 10, 'days')
) 

JB