
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jun 11, 2020 10:04 AM
I have a formula I can’t figure out.
My column that I want as a formula is called “Forecasted SCIP Received” To calculate this date, I need to use another column called “Actual Site Walk Date” plus a “Duration” column. However, if “Actual Site Walk Date” is empty, I need it to use “Forecasted Site Walk Date” instead, so: If the “Actual Site Walk Date” is not Empty, then “Actual Site Walk Date” + “Duration”. But if Actual Site Walk Date is empty, then “Forecasted Site Walk Date” + “Duration” How do I write this?
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jun 11, 2020 11:09 AM
You can use a formula field with the IF
function and DATEADD
. They are documented in the formula field reference. Note that duration fields store time in seconds, so you need to specify to add seconds.
IF({Actual Site Walk Date},
DATEADD({Actual Site Walk Date}, {Duration}, 'seconds'),
DATEADD({Forecasted Site Walk Date}, {Duration}, 'seconds')
)
If this answers your question, please mark this post as the solution. Otherwise, could you please give a bit more details and a screen capture?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jun 11, 2020 11:09 AM
You can use a formula field with the IF
function and DATEADD
. They are documented in the formula field reference. Note that duration fields store time in seconds, so you need to specify to add seconds.
IF({Actual Site Walk Date},
DATEADD({Actual Site Walk Date}, {Duration}, 'seconds'),
DATEADD({Forecasted Site Walk Date}, {Duration}, 'seconds')
)
If this answers your question, please mark this post as the solution. Otherwise, could you please give a bit more details and a screen capture?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jun 11, 2020 11:12 AM
I think something like this should do it for you:
Was in the middle of writing this when @kuovonne answered. My formula is essentially the same, just condensed a little – I’ll still post it in case it’s preferable, but please mark @kuovonne’s answer as the solution :slightly_smiling_face:
DATEADD(
IF({Actual Site Walk Date}, {Actual Site Walk Date}, {Forecasted Site Walk Date}),
{Duration},
'seconds'
)

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jun 11, 2020 02:48 PM
Thank you! This worked for me! :slightly_smiling_face: :grinning_face_with_big_eyes:

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jun 11, 2020 02:49 PM
Thank you! Appreciate the follow up!
