Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

DATETIME_FORMAT return as "Pending" instead of #ERROR!?

Topic Labels: Formulas
Solved
Jump to Solution
385 2
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi! I’ve been using the below formula for awhile, but it returns an #ERROR! for the fields where {FOC (Current)} is blank. For cleaner reporting I’d like to have it return as “PENDING” but can’t seem to get an IF formula to work successfully. Any suggestions?

DATETIME_FORMAT({FOC (Current)},‘YYYY, MM (MMMM)’)

1 Solution

Accepted Solutions

Here you go:

IF({FOC (Current)},DATETIME_FORMAT({FOC (Current)},'YYYY, MM (MMMM)'),"PENDING")

See Solution in Thread

2 Replies 2

Here you go:

IF({FOC (Current)},DATETIME_FORMAT({FOC (Current)},'YYYY, MM (MMMM)'),"PENDING")

Worked perfectly! thank you