Get rid of #ERROR! in formula field?

Can someone help me with my formula? I have an “aging” column that I use to show months since the publish date of my blog posts. This works well when I have a publish date, but, for unscheduled posts it returns an ugly #ERROR!

I would like it to either show blank, or N/A. Here’s my formula.

DATETIME_DIFF(TODAY(),{Publish Date},'months')

Just surround the whole thing in a conditional that checks for the presence of a Publish Date:

IF(
   {Publish Date},
   DATETIME_DIFF(
      TODAY(),
      {Publish Date},
      'months'
   )
)
1 Like

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.