Max Amount within same object

Hi,

I have a bunch of properties within contacts with an amount.

profit Q1

profit Q2

etc…

I want to be able to have a property “max profit” which tells me which of the properties profit Q1, Q2, etc.. is the biggest.

It doesnt seem possible with the max property in calculation.

Is there a workaround?

Thanks

Hi @dmattauch,

As far as I know HubSpot does not have a specific feature for this. It would either require a custom code action (available in Operations Hub Professional) or a third-paryt integration (e.g. Zapier / Google Sheets) to identify and store the max value.

Let me know if you have any follow-up questions!

Best regards!