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

Smart CRM & Sales Hub CRM
,
1

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

2

Hi @PJohns,

With the configuration below, it should work:

karstenkoehler_0-1724329736070.png
karstenkoehler_0-1724329736070.png885×1031 77.9 KB

Are you experiencing a different outcome?

Best regards!

3

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