Question

IF Formula multiple criteria

+9

Hi, can someone people assist with my formula? This is what I’m currently working with;

IF({Post Sale Date},{Post Sale Date},{Event Date})

I want to expand on this to check the ‘Result’ field so it functions as below.

IF ‘Post Sale Date’ exists then use ‘Post Sale Date’

IF ‘Post Sale Date’ is empty and ‘Result’ is not ‘SUTH’ then leave blank.

IF ‘Post Sale Date’ is empty and ‘Result’ is ‘SUTH’ then use ‘Event Date’

Any suggestions would be much appreciated! Thank you

+31

Does this look right?

IF(
  {Post Sale Date},
  {Post Sale Date},
  IF(
    Result = 'SUTH',
    {Event Date}
  )
)

Adam, Airtable Consultant - thetimesaving.company

+28

Hey @TheTimeSavingCo,

Adam’s formula above should work. However, if you need further help setting this up please feel free to grab a slot using this link. I’d be happy to hop on a quick call and show you around.

Mike, Consultant @ Automatic Nation

Sign up