DATEADD & IF

[Lisa_Wetherby]

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!

[Sho]

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]

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.