Help

Formula Help: IF statement to override calculated date field with a manual date

Topic Labels: Formulas
Solved
Jump to Solution
1246 4
cancel
Showing results for 
Search instead for 
Did you mean: 
beder
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi Airtable community! Hoping for some assistance with an If statement.

We have a workback schedule for deliverables based on an event date
Workback:Materials Due: WORKDAY(Date,-45))

Occasionally, we will need to adjust the deliverable dates if the date of the event is determined later than the typical schedule allows for. I created a “Manual Deadline” date field.
Manual: Materials Due: DATE

I would like to create an If statement Formula field for Materials Due that will populate it with the Workback: Materials Due date UNLESS the Manual: Materials Due field has a date in it, in which case it will display the manual date.

Can someone please assist? My brain has trouble with if statements :winking_face:

1 Solution

Accepted Solutions
Vivid-Squid
11 - Venus
11 - Venus

IF({Manual: Materials Due} = “”,WORKDAY({Date},-45),{Manual: Materials Due})

See Solution in Thread

4 Replies 4
Vivid-Squid
11 - Venus
11 - Venus

IF({Manual: Materials Due} = “”,WORKDAY({Date},-45),{Manual: Materials Due})

beder
5 - Automation Enthusiast
5 - Automation Enthusiast

You rock Vivid Squid! :squid:

No problem.

IF formulas are not too tricky. I think of them like this: There are 3 sections to an IF statement.

  1. A thing that will be true
  2. When number 1 is true do this
  3. When number 1 is not true do this

Each section is separated by a comma.

So in our formula we have: {Manual: Materials Due} = “”, saying to be true this field will be blank. Then the next section is if that is true subtract 45 days from date. Then the last section is If not true (blank) show the manual date.

beder
5 - Automation Enthusiast
5 - Automation Enthusiast

Thank you for breaking this down. I thought that I would have to create a third Deliverables Date field but the formula you sent me works perfectly and makes sense!