Skip to main content

DATEADD & IF

  • May 27, 2024
  • 2 replies
  • 12 views
Lisa_Wetherby
Forum|alt.badge.img+6
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

S
Forum|alt.badge.img+21
  • Sho
  • Inspiring
  • May 27, 2024

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
Forum|alt.badge.img+6
  • Lisa_Wetherby
  • Author
  • Participating Frequently
  • May 30, 2024

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.

Terms & ConditionsAccessibility statement