Skip to main content

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

Here you go:

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


Here you go:

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


Worked perfectly! thank you