Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Re: IF THEN Formula to remove error (complex formula)

Solved
Jump to Solution
1498 0
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"
)