Skip to main content

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

Does this look right?

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

 

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 

Terms & Conditions