Help

DATEADD & IF

Topic Labels: Formulas
177 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Lisa_Wetherby
6 - Interface Innovator
6 - Interface Innovator
Hi - I use this formula to figure out when to follow up with applicants:
 
DATEADD({Initial Email Sent}, 2, 'week')
 
But I'd like to have it return a different result (1 week vs 2) when my applicants are getting fast-tracked.
 
I tried this:
 
DATEADD(
  IF({Send Initial Email}, "Initial Email"{Initial Email Sent}, 2, 'week',
"FastTrack Initial Email", 1, 'week'))
 
But it didn't work. Do you have any suggestions for me?
 
Thank you!
2 Replies 2
Sho
11 - Venus
11 - Venus

Hi @Lisa_Wetherby,

DATEADD and IF statements need to be separated.

IF({Send Initial Email}, 
  DATEADD({Initial Email Sent}, 2, 'week'),
  DATEADD({FastTrack Initial Email}, 1, 'week')
)
Lisa_Wetherby
6 - Interface Innovator
6 - Interface Innovator

Nope.

I thought the problem might be that Send Initial Email is a field and Initial Email And FastTrack Initial Email are options in that field, so I played around with that some. Still didn't get it to work.