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')
1 Like

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

   {Publish Date},
      {Publish Date},

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