Help

Re: Formulas and dates

556 0
cancel
Showing results for 
Search instead for 
Did you mean: 
richard_snell
4 - Data Explorer
4 - Data Explorer

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