Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 27, 2024 10:19 AM
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

Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 27, 2024 04:31 PM
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')
)
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 30, 2024 07:27 AM
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.
