Skip to main content
Solved

IF THEN Formula to remove error (complex formula)

  • January 3, 2023
  • 2 replies
  • 42 views
E
Forum|alt.badge.img+3

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

Best answer by EPerez

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

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

    2 replies

    J
    Forum|alt.badge.img+9
    • John_B2
    • Inspiring
    • January 3, 2023

    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"), "")
    E
    E
    Forum|alt.badge.img+3
    • EPerez
    • Author
    • New Participant
    • Answer
    • January 3, 2023
    Good callout with the date field. Here's what fixed it: 

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