It seems that often a request gets over-analyzed. @smcmillian replied offering a more complex solution using DataSets and asked for feedback. From what I can tell, a couple of users gave good examples for why DataSets wouldn’t be a solution. The original request, and one that I also need, is simply to increase the number of conditions. I bet just adding one or two more conditions would resolve most people’s need. In my case we have a “SITES” or locations module that looks just like a Company, but the SITES are associated to a Company, as we track revenue and implementation by SITE/Location. AND we need to be able to count the number of Sites where (condition 1) SITE STATUS = ACTIVE, AND (condition 2) SITE PRODUCT = X. So we just need one more condition for the calculated value. Maybe there is a complex reason that HubSpot cannot programmatically accomplish this, but for those of us that are semi-technical or technical, it is frustrating when what seems like a simple solution is over-looked or over engineered, especially one that is being requested by third party soution providers that help sell and customize HubSpot for end users! And as @JessKing86 says: “It’s been incredibly painful to get around the barrier of just one condition on a calculated field. It looks like this has been getting talked about since 2020? Why not just make the adjustment and delay the other menial updates?”
This one simple change can help so much. Is HubSpot afraid this will keep customers from upgrading? We are Enterprise level and we need this.