Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Formula Help Needed

Topic Labels: Formulas
Solved
Jump to Solution
363 4
cancel
Showing results for 
Search instead for 
Did you mean: 

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?

1 Solution

Accepted Solutions

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?

See Solution in Thread

4 Replies 4

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?

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

Thank you! This worked for me! :slightly_smiling_face: :grinning_face_with_big_eyes:

Thank you! Appreciate the follow up!