IF THEN Formula to remove error (complex formula)

[EPerez]

Hi!

Right now I get an #ERROR in Column A when the date is blank. However, I'd like it to return "N/A" instead.

The formula below still results in an error.  What do you suggest?

IF(

{Formatted Date},

CONCATENATE(

{Formatted Date}," - ",{Event/Release}

), "N/A"

)

[John_B2]

The error is possibly coming from the {Formatted Date} field that I'm assuming is something like this  :

DATETIME_FORMAT({your date name},"YYYY-MM-DD")
If so change it to :

IF( {your date name} , DATETIME_FORMAT({your date name},"YYYY-MM-DD"), "")

[EPerez · Accepted solution]

Good callout with the date field. Here's what fixed it: 

IF(

{Date},

CONCATENATE(

{Formatted Date}," - ",{Event/Release}

), "N/A"

)