Formula to Correct #ERROR! for Empty Date Field

[John_Dlouhy]

Hello Airtable Community,

My table includes an event title field as well as one for an event date.

Event Title:
The Chemical Regulations Landscape

Event Date:
June 6, 2004

Formula:
LEFT({Event Title}, 16)&" - "&{Date}

Formula Result:
The Chemical Reg - 6/6/2024

All good so far…but there are also records that have an event title and no event date, so the formula above  returns #ERROR! for these records.

So, for the records sans event date, how can I modify the formula so that it returns the first 16 characters of the event name instead of generating an error?

Many thanks in advance for your assistance!

John

[Sistema_Aotearo · Accepted solution]

Hiya! Try this formula and let me know if it works for you!

LEFT({Event Title}, 16) &
IF(NOT(
   {Date}=""),
   " - " & DATETIME_FORMAT({Date}, "DD-MM-YYYY")
)

[John_Dlouhy]

👍Thank you very much! Greatly appreciated!