--- title: Ask PT About Using Formulas in Rollup Summaries in Salesforce description: Salesforce doesn't allow rollup summaries using formula fields with date functions, but there is an easy solution to this problem. image: https://www.passagetechnology.com/hubfs/ASK%20PT%20gif15.gif --- [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) # Ask PT About Using Formulas in Rollup Summaries in Salesforce 2022/03/29 [![Free Salesforce business guides to help admins/developers, project managers, sales managers, and decision makers. Download the free PDF series now: Reinventing Your Business, Reimagining Your Salesforce®.](https://www.passagetechnology.com/hubfs/2021/Essential-Salesforce-Guide_Helper-Suite.png) ](https://www.passagetechnology.com/en/essential-guide-for-salesforce-admins-developers) *Dear PT, * *At our company, we are having trouble seeing the number of open Projects with an Account or Opportunity. Can you help? Salesforce’s native rollup summary fields can’t be used with certain formulas, specifically formula fields with date functions. Hence, we can’t create the list of open projects as of today (or any other date).* *Asov Toodae from Worksop, UK* Dear Asov, Yes, rollup summary fields can only use static criteria. As it turns out, this was one of the many Salesforce rollup limitations that initially inspired the creation of [Rollup Helper](https://www.passagetechnology.com/rollup-helper-overview) nearly a decade ago. (Rest assured, Rollup Helper does much more than solve this problem.) Yours is a very specific problem, but there are many other use cases that are similarly complicated by this huge limitation—Rollup Helper's ability to roll up information using date-based criteria could also be used for those other situations. But to answer your question, follow these steps to [create the number of open Projects on Opportunity](https://www.passagetechnology.com/rollup-helper-use-cases/roll-ups-using-formulas-rather-than-static-criteria). Sincerely, PT *** Check out other [Ask PT advice columns](https://www.passagetechnology.com/passage-technology-blog/tag/ask-pt). [Submit your own question to PT](https://www.passagetechnology.com/en/ask-pt). You may see it used in a future installment in this series. Tags: [Rollup Helper](https://www.passagetechnology.com/passage-technology-blog/topic/rollup-helper), [Rollup Summary Field](https://www.passagetechnology.com/passage-technology-blog/topic/rollup-summary-field), [data rollups](https://www.passagetechnology.com/passage-technology-blog/topic/data-rollups), [Ask PT](https://www.passagetechnology.com/passage-technology-blog/topic/ask-pt) | [** Overcome IT Project Management Challenges & Cost Overruns ](https://www.passagetechnology.com/passage-technology-blog/project-management-costs) | [Passage Technology Blog](https://www.passagetechnology.com/passage-technology-blog) | [ Financial Service Industry Trends Lead to New Data Challenges ** ](https://www.passagetechnology.com/passage-technology-blog/financial-industry-data) | | --- | --- | --- | [ 7 Popular Use Cases that Lighten the Load for Salesforce Admins ](https://www.passagetechnology.com/passage-technology-blog/use-cases-admins) [ What is technical debt, and how can you avoid it in Salesforce? ](https://www.passagetechnology.com/passage-technology-blog/what-is-technical-debt-and-how-can-you-avoid-it-in-salesforce) [ Learning from Rollup Helper’s Supportive Trailblazer Community ](https://www.passagetechnology.com/passage-technology-blog/rollup-helpers-supportive-trailblazer-community-app-resources) [ Passage Technology News and Updates – Spring 2026 ](https://www.passagetechnology.com/passage-technology-blog/news-spring-2026) [ True Effectiveness with Salesforce Agentforce Requires Elevating Data Quality First ](https://www.passagetechnology.com/passage-technology-blog/true-effectiveness-with-salesforce-agentforce-requires-elevating-data-quality-first) [ Roll-up Solution When a Roll-up Summary Field Can't be Used ](https://www.passagetechnology.com/passage-technology-blog/roll-up-solution-when-a-roll-up-summary-field-can-not-be-used-and-process-builder-does-not-fire-on-delete) [ GDPR and Using the Salesforce Individual Object ](https://www.passagetechnology.com/passage-technology-blog/gdpr-and-the-using-the-salesforce-individual-object) [ Can’t Create Quote From Opportunity in Lightning Using New Quote Button? ](https://www.passagetechnology.com/passage-technology-blog/new-quote-button) [ Rollup Helper vs Declarative Lookup Roll-up Summaries (DLRS) ](https://www.passagetechnology.com/passage-technology-blog/rollup-helper-vs-declarative-lookup-roll-up-summaries-dlrs) [ Passage Technology News & Updates – Winter 2026 ](https://www.passagetechnology.com/passage-technology-blog/passage-technology-news-updates-winter-2026) © 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" : "PT", "url" : "https://www.passagetechnology.com/passage-technology-blog/author/pt" }, "dateModified" : "2022-06-15T15:38:49.633Z", "datePublished" : "2022-03-29T13:36:26.000Z", "headline" : "Ask PT About Using Formulas in Rollup Summaries in Salesforce", "image" : [ "https://www.passagetechnology.com/hubfs/ASK%20PT%20gif15.gif" ], "mainEntityOfPage" : { "@id" : "https://www.passagetechnology.com/passage-technology-blog/ask-pt-about-using-formulas-in-rollup-summaries-in-salesforce", "@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" } } ```