+5Hi! 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)’)
Best answer by ScottWorld
Here you go:
IF({FOC (Current)},DATETIME_FORMAT({FOC (Current)},'YYYY, MM (MMMM)'),"PENDING")
+35Here you go:
IF({FOC (Current)},DATETIME_FORMAT({FOC (Current)},'YYYY, MM (MMMM)'),"PENDING")
+5Here you go:
IF({FOC (Current)},DATETIME_FORMAT({FOC (Current)},'YYYY, MM (MMMM)'),"PENDING")
Worked perfectly! thank you
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.