Possible to use formula to show a percentage in a property, based on 2 other properties?

[PJohns]

Hi,

Loving the fact we can create formulas in HubSpot, populating property fields with the results!

But, stuck on this one. Is this possible? We have these 2 properties created in HubSpot:

Property 1: Storage Permitted (number)

Property 2: Storage Used (number)

And then in Property 3 (using a formula) either:

a) Show when Property 2 (storage used) reaches 95% of Property 1 (storage permitted).

or

b) Show the actual percentage of storage used between Property 1 (storage permitted) and Property 2 (storage used).

Been trying to use a % in the formula but it doesn't seem to like it unless I am formatting it incorrectly?

Any help would be much appreciated.

Thanks, Paul

[karstenkoehler · Accepted solution]

Hi @PJohns,

With the configuration below, it should work:

Are you experiencing a different outcome?

Best regards!

[PJohns]

Hi,

Forgot to look at the Number Format (Percentage) option! Was trying to use custom formula, my mistake LOL!

That works a treat. I have just built an automation off the back of this to notify us internally when a specific percentage is used!

Really helpful, thanks - Paul