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

[Shawntel_Cote]

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

[ScottWorld · Accepted solution]

Here you go:

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

[Shawntel_Cote]

Worked perfectly! thank you