Skip to main content

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

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

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

👍Thank you very much! Greatly appreciated!

Reply


Terms & Conditions