Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

IF THEN Formula to remove error (complex formula)

Topic Labels: blank ERROR
Solved
Jump to Solution
1837 2
cancel
Showing results for 
Search instead for 
Did you mean: 
EPerez
4 - Data Explorer
4 - Data Explorer

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
EPerez
4 - Data Explorer
4 - Data Explorer
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
John_B2
6 - Interface Innovator
6 - Interface Innovator

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
4 - Data Explorer
4 - Data Explorer
Good callout with the date field. Here's what fixed it: 

IF
(
{Date},
CONCATENATE(
{Formatted Date}," - ",{Event/Release}
), "N/A"
)