Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

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

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

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

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

See Solution in Thread

4 Replies 4

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

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.

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!