Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

IF THEN Formula to remove error (complex formula)

posted Jan 3, 2023 11:32:11 AM

Topic Labels: blank ERROR

Solved

Jump to Solution

0 146 2

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"

)

1 Solution

Accepted Solutions

Solved

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

IF(

{Date},

CONCATENATE(

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

), "N/A"

)

See Solution in Thread

2 Replies 2

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"), "")

Solved

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

IF(

{Date},

CONCATENATE(

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

), "N/A"

)