Help

Re: Formula to Correct #ERROR! for Empty Date Field

Solved
Jump to Solution
508 1
cancel
Showing results for 
Search instead for 
Did you mean: 
John_Dlouhy
7 - App Architect
7 - App Architect

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

1 Solution

Accepted Solutions

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

Justin Ng
Programme Coordinator at Sistema Aotearoa
https://www.sistemaaotearoa.org.nz/

See Solution in Thread

2 Replies 2

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

Justin Ng
Programme Coordinator at Sistema Aotearoa
https://www.sistemaaotearoa.org.nz/

👍Thank you very much! Greatly appreciated!