+18I 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')
Best answer by Alexey_Gusev
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'))
+18Now 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
+25Now 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'))
+18Hi,
the correct syntax should be something like:
IF({Original Launch Date},
IF(IS_AFTER({Launch Date},{Original Launch Date}),'Launch Delayed'))
Perfect! thank you!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.