Skip to main content

Can someone help me figure out why the ‘else’ part of my IF statement isn’t working?

I'm trying to create a friendly date/time/timezone field IF a certain date field is not blank. That part is working. But if the date field is blank, I want it to put “N/A” in the new field. That part is returning an error.

Here is my formula.

IF(

 {REQUESTED GO LIVE DATE} !=BLANK(),

  DATETIME_FORMAT({REQUESTED GO LIVE DATE}, 'M/D/YY') & " at " & {REQUESTED GO LIVE TIME} & " " & {GO LIVE TIME ZONE}, "N/A"

)

I also tried it this way:

IF(

  {REQUESTED GO LIVE DATE} !=BLANK(),

  DATETIME_FORMAT({REQUESTED GO LIVE DATE}, 'M/D/YY') & " at " & {REQUESTED GO LIVE TIME} & " " & {GO LIVE TIME ZONE},

IF({REQUESTED GO LIVE DATE}=BLANK(),"N/A"

))

But neither formula is recognizing what to do if the REQUESTED GO LIVE DATE field is blank. Oddly, it is working when I remove the first part of the formula to only look for blank date field. 

IF({REQUESTED GO LIVE DATE} = BLANK(),"N/A"

)

Attached is a screenshot of the results.

Hey @bmcad1116, 

Try this formula:

TRIM( IF( {REQUESTED GO LIVE DATE}, DATETIME_FORMAT( {REQUESTED GO LIVE DATE}, 'M/D/YY' ) & IF( {REQUESTED GO LIVE TIME}, ' at ' ) ) & IF( AND( {REQUESTED GO LIVE DATE}, {REQUESTED GO LIVE TIME} ), {REQUESTED GO LIVE TIME} & IF( {GO LIVE TIME ZONE}, ' ' & {GO LIVE TIME ZONE} ) ) )

Hi, 
In short, you don't need to use BLANK() word, Just IF({Field}, [expression when Field not empty] , [output when Field is blank] ). The last can be omitted, default is blank, so IF ({Field} , [expression] ) also works.

Terms & ConditionsAccessibility statement