Prospect List based on Company field that is NOT greater than 0

[mmetros]

I am creating a prospect list and need to create a criteria that says "Add to list if Field is not greater than 0".

Unfortunately, Hubspot does not off the logic of "Not greater than", so I have to figure out a workaround in the meantime.

Anybody know how we can achieve "Not greater than" in hubspot?

[PamCotton]

Hello @mmetros 

You are able at the moment to sort "greater than" or "less than" for any properties that have the "number" property type.

For example, if you go to add a filter for "recent deal amount" (which is a number-field type), then you get the ability to sort by is "greater than" or is "less than."

Check if the property you are using is a single-line text property, if so, currently, it is not possible to filter because these properties are text entries.

As a workaround, you could filter for the property you would like "is known", export those contacts into Excel, and sort from there. Or you could build a new property that is a "number" property type to allow you to sort within HubSpot.

I hope this information helps.

Pam

[mmetros]

This is a integer/double field type. There is still not a parameter for "NOT GREATER THAN"

[PamCotton]

Hello @mmetros 

For not greater than" you will use the option "less than."

Kindly,

Pam