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
Formulas and dates
+18Hi @richard_snell - try this (adds 10 days):
IF(
{Your word field} = 'Your special word',
DATEADD({Date}, 10, 'days')
)
JB
Login to the community
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.