Help

Get rid of #ERROR! in formula field?

Solved
Jump to Solution
1504 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Crissy_Page
4 - Data Explorer
4 - Data Explorer

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 Solution

Accepted Solutions
Jeremy_Oglesby
14 - Jupiter
14 - Jupiter

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

See Solution in Thread

1 Reply 1
Jeremy_Oglesby
14 - Jupiter
14 - Jupiter

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