Skip to main content
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!

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')
)

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.

Reply


Terms & Conditions