Single Property to combine Multiple properties

[AbhiB]

Hey Team,

I am currently working on multiple reports and came across a challenge while building reports related to Deal Stage movement timestamps.

At present, to generate the required output, I need to manually drag and drop multiple “Date Entered Stage” properties for each individual deal stage into the report. As the number of stages increases, the process becomes repetitive and difficult to manage.

What I wanted to check is whether there is a possibility to create a single consolidated property for example, “Date Entered in Different Stages” which can capture or combine the timestamps from all the individual stage-entry properties and provide the same output in reports.

The expected output would remain exactly the same, the only difference is that instead of adding 7–8 separate stage properties every time, we could simply use one consolidated property in the report.

Kindly look into the feasibility of this approach. Please let me know if you need any additional information or clarification from my end I’ll be happy to help.

Thanks & Best Regards,
AB.

[GRajput]

Hi @AbhiB

We cannot create a single HubSpot calculation property that combines the Date Entered in Deal Stage values from all the different deal stages into one property. A calculation property can be used to calculate the total number of days spent across stages; we could potentially use a custom text property and populate it through a workflow or custom code, but it wouldn’t work the same way as the individual stage date properties when it comes to reporting. So, for the current requirement, the individual Date Entered Deal Stage properties would still need to be used in the report

I hope this helps you out. Please mark it as Solution Accepted and Like to help another Community member.
This post was created with the assistance of AI tools

Thanks!