Skip to main content

I cannot decide if I'm better off with an automation or else I'm just not meant to do if else formulas. I need to first check if a date field is not blank. If it is not blank, then I want to compare it with another date field. If it's later than other date field I want to show 'launch date moved out'. I know this formula is not comparing but it's what I ended up with (and it's not working)

IF({Original Launch Date} & "-"

THEN {Launch Date}>{Original Launch Date},'Launch Delayed')

 

Now that I've had a moment to reflect, my question is actually:

IF({Launch Date}>{Original Launch Date} & {Original Launch Date} & "-" & },'Launch Delayed')

I want to compare two dates only if one of the dates field is not blank

 

Now that I've had a moment to reflect, my question is actually:

IF({Launch Date}>{Original Launch Date} & {Original Launch Date} & "-" & },'Launch Delayed')

I want to compare two dates only if one of the dates field is not blank

 


Hi,
the correct syntax should be something like:

IF({Original Launch Date},
IF(IS_AFTER({Launch Date},{Original Launch Date}),'Launch Delayed'))

 

Hi,
the correct syntax should be something like:

IF({Original Launch Date},
IF(IS_AFTER({Launch Date},{Original Launch Date}),'Launch Delayed'))

 


Perfect! thank you!

Reply


Terms & Conditions