Skip to main content
Solved

Getting ERROR in Calculated DATEADD Blank Records

A
  • AM858
  • Participating Frequently
  • 8 replies

I’m tracking properties that are on the market and haven’t sold. I can pull a data source which gives me “Days on Market” as a number. I can then use DATEADD() to subtract the num of days from the date entered 6/13/21 in this case, to get the start date of the listing.

But there are cases where I know a property is being sold, but I don’t have a date it first hit the market, so it results in an error.

Not sure if this will be a problem, but I tried to use an ISERROR formula but wasn’t able to get it working.

Best answer by Kamille_Parks11

If you want to show a blank field instead of an error:

IF(
   {Days on Market},
   DATEADD(...)
)
View original
Did this topic help you find an answer to your question?

3 replies

Kamille_Parks11
Forum|alt.badge.img+15

If you want to show a blank field instead of an error:

IF(
   {Days on Market},
   DATEADD(...)
)
A
  • AM858
  • Author
  • Participating Frequently
  • 8 replies
  • June 14, 2021
Kamille_Parks11 wrote:

If you want to show a blank field instead of an error:

IF(
   {Days on Market},
   DATEADD(...)
)

Any reason I should have to error message set to anything? For example some properties I won’t know when they go to market (if they aren’t publicly listed). Trying to think ahead if it will affect any filtering/sorting process I use down the road where a blank value isn’t helpful.

Kamille_Parks11
Forum|alt.badge.img+15
AM858 wrote:

Any reason I should have to error message set to anything? For example some properties I won’t know when they go to market (if they aren’t publicly listed). Trying to think ahead if it will affect any filtering/sorting process I use down the road where a blank value isn’t helpful.


Its not advised to have mixed-type fields, meaning a field meant for dates (like this one) should only show a date or a blank. As such I wouldn’t recommend adding a custom error message to this field, but you could use a separate formula field to display a message if you need it for filtering purposes.

A
1 person likes this
  • A
    AM858

Reply


Most helpful members this week

Terms & Conditions