--- title: Rollup Helper and Lookup Helper Customer Success Story | Customer Success description: See how Rollup Helper and Lookup Helper empower Ashberry Water Conditioning to overcome sales pipeline congestion. image: https://www.passagetechnology.com/hubfs/Ashberry%20Water%20Logo%20200x400px.png --- [GET DEMO](https://www.passagetechnology.com/any-product-one-on-one) **+1 (224) 655-6779 [![Trusted Salesforce service partner Passage Technology](https://www.passagetechnology.com/hubfs/2021/Nav-header-logo_PT.png) ](https://www.passagetechnology.com) # Rollup Helper & Lookup Helper Streamline Sales Pipeline for Ashberry Water Conditioning ![Ashberry Water logo](https://www.passagetechnology.com/hs-fs/hubfs/Ashberry%20Water%20logo.png?width=238&height=91&name=Ashberry%20Water%20logo.png)   [Ashberry Water Conditioning](https://www.ashberrywater.com/) is a Florida company that provides commercial water treatment services to businesses, educational facilities, municipalities, and industry. Their mission is to provide customers with quality water needed to run their businesses, increase their profitability, and improve their lives. Michelle Johnson, who is the Salesforce Admin & Sales Support at Ashberry, was searching for a solution to a problem that they were experiencing in their org and discovered that Passage Technology could help. ## Pipeline Congestion: Sales Team Quoting on the Same Project With Multiple Contractors Ashberry was trying to filter the amount for Opportunities shown. However, multiple Opportunities all shared the same name, which was used for bids on construction projects. Michelle adds, “Our sales team members quote on the same project/job to multiple contractors who are all bidding for the same job, so the pipeline would get inflated.” ## New Setting Links Opportunities to a Bid Spec Record & Filtering Quotes To prevent their Opportunity Pipeline from getting congested, Passage Technology created a new Bid Spec Object, along with a [Lookup Helper](https://www.passagetechnology.com/lookup-helper-overview) setting that links all Opportunities for the same bid to a Bid Spec Record. A formula checkbox field marks the Opportunity with the highest amount for that bid spec, and the formula field can be used to only show one Opportunity per job within the pipeline. “Through [Rollup Helper](https://www.passagetechnology.com/rollup-helper-overview), we were able to filter out duplicate quotes from the sales pipeline, as well as by using a formula to count only the highest quote amount for the same job. Now a simple filter easily updates our sales team members’ pipeline in a matter of seconds vs. one to two hours a week filtering out per record,” said Michelle. Michelle is thrilled with the results. She said, “Finally, Sales, Manager Dashboards, and their Pipelines are reporting concrete numbers!” ### Learn more about [Rollup Helper](https://www.passagetechnology.com/rollup-helper-overview) and [Lookup Helper](https://www.passagetechnology.com/lookup-helper-overview) Tags: [Rollup Helper](https://www.passagetechnology.com/customer-success/topic/rollup-helper), [Lookup Helper](https://www.passagetechnology.com/customer-success/topic/lookup-helper), [Opportunity Pipeline](https://www.passagetechnology.com/customer-success/topic/opportunity-pipeline) | [** Swivl Uses Rollup Helper to Manage Data as They Expand in the Education Tech Space ](https://www.passagetechnology.com/customer-success/rollup-swivl-customer-story) | [Customer Success](https://www.passagetechnology.com/customer-success) | [ Development Team Provider Optimizes Invoicing & Account Management with Rollup Helper ** ](https://www.passagetechnology.com/customer-success/rollup-mobilunity-customer-story) | | --- | --- | --- | [ Rollup Helper Elevates AI Company's Revenue Reporting With Connected Account & Product Data ](https://www.passagetechnology.com/customer-success/rollup-helper-enhances-capacitys-revenue-reporting) [ Aggregating Customer Success Data: Research Leads ISI Analytics to Rollup Helper ](https://www.passagetechnology.com/customer-success/aggregating-customer-success-data-research-leads-isi-analytics-to-rollup-helper) [ Benecon Leverages Rollup Helper for Multiple Time-Saving Use Cases ](https://www.passagetechnology.com/customer-success/rollup-helper-saves-time) [ Rollup Helper Provides Sales Insights Needed for Data-Driven Decisions ](https://www.passagetechnology.com/customer-success/rollup-helper-sales-insights) [ Rollup Helper Simplifies CPQ Calculation Process for Kipu Health ](https://www.passagetechnology.com/customer-success/rollup-helper-cpq-kipu) [ Rollup Helper Elevates AI Company's Revenue Reporting With Connected Account & Product Data ](https://www.passagetechnology.com/customer-success/rollup-helper-enhances-capacitys-revenue-reporting) [ Dakota Financial Uses Rollup Helper to Make Smooth Transition to Salesforce ](https://www.passagetechnology.com/customer-success/rollup-dakota-customer-story) [ Aggregating Customer Success Data: Research Leads ISI Analytics to Rollup Helper ](https://www.passagetechnology.com/customer-success/aggregating-customer-success-data-research-leads-isi-analytics-to-rollup-helper) [ Benecon Leverages Rollup Helper for Multiple Time-Saving Use Cases ](https://www.passagetechnology.com/customer-success/rollup-helper-saves-time) [ Rollup Helper + Lookup Helper: A Winning Combination for Aspire ](https://www.passagetechnology.com/customer-success/rollup-lookup-aspire-customer-story) © 2026 Passage Technology LLC All Rights Reserved. [Privacy Policy](https://www.passagetechnology.com/privacy-policy) | [Purchasing & Legal](https://www.passagetechnology.com/purchasing-and-legal) | [Terms of Service](https://www.passagetechnology.com/terms-of-service) | [App Security](https://passagetech.my.site.com/KnowledgeBase/s/article/Security-and-Privacy-Policy-1578080055496) - [** ](https://www.facebook.com/passagetech) - - [** ](https://www.linkedin.com/company/passage-technology) - [** ](https://www.youtube.com/channel/UCK2tzaCWVC7PmFCXrLirnZw) ```json { "@context" : "https://schema.org", "@type" : "BlogPosting", "author" : { "@type" : "Person", "name" : "Carrie Brown", "url" : "https://www.passagetechnology.com/customer-success/author/carrie-brown" }, "dateModified" : "2026-04-16T13:22:54.723Z", "datePublished" : "2023-07-06T14:03:07.000Z", "headline" : "Rollup Helper and Lookup Helper Customer Success Story ", "image" : [ "https://www.passagetechnology.com/hubfs/Ashberry%20Water%20Logo%20200x400px.png" ], "mainEntityOfPage" : { "@id" : "https://www.passagetechnology.com/customer-success/ashberry-water", "@type" : "WebPage" }, "publisher" : { "@type" : "Organization", "logo" : { "@type" : "ImageObject", "url" : "https://www.passagetechnology.com/hubfs/Logo%20PT_colors_wide_on-white.png" }, "name" : "Passage Technology LLC" } } ```