--- title: Number of Call Attempts to get a Discussion | Rollup Helper Use Case Library description: With Rollup Helper, you can view this sales metric in Salesforce and a get a filtered list view of the prospects to call with results from previous calls. image: https://www.passagetechnology.com/hubfs/Imported_Blog_Media/List+View+-+Contact+Attempts-1.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) # Number of Call Attempts to get a Discussion [![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) ## Problem: As a Sales Manager, I need to know how many outbound call attempts it takes to achieve a discussion.   ## Additionally, so that my reps are more productive, I need a filtered list view of the prospects that they should call that includes the results from previous calls. ## Solution: Use Rollup Helper to count the number of calls except those that resulted in a discussion and to rollup the Call Results.   ## In order to have the count stop once a discussion is achieved, we will also need to use a workflow field update. 1. Create a custom picklist field on Task (Call Result).  Example Values: 1. No Answer 2. Wrong Number 3. Disconnected Number 4. Left Voicemail 5. Left Message 6. Answer and Discussion 2. Create a text area field on Contact (Call Results) 3. Create a formula (checkbox) field on Contact (Answer and Discussion) 1. CONTAINS(Call_Results__c, 'Answer and Discussion') 4. Create a number field on Contact (Number of Calls) 5. Create a number field on Contact (Number of Calls to Get Discussion) 6. Create a Count Rollup 1. Rollup Helper Step 1) Select Contact as the Object you would like to roll up to. 2. Rollup Helper Step 2) Select “Number of Calls” as the field you would like to update. 3. Rollup Helper Step 3) 1. Select Task as the Child Object with Name ID-Task.WhoId as the relationship. 2. Select Deleted as the field on Task to use as a source. 3. Select Count 4. Add a New Custom Filter (Completed Calls, No Discussion) 1. Leave the Limit to box blank. 2. No sort order necessary 3. Specify Filter Criteria 1. Keep isDeleted = False 2. Status = Completed 3. Type = Call 4. Call Result != Answer and Discussion (be sure to use your custom picklist field, not the standard one) 5. Save and Run the rollup or run in real-time. 7. Create a Text Rollup. 1. Rollup Helper Step 1) Select Contact as the Object you would like to roll up to. 2. Rollup Helper Step 2) Select “Call Results” as the field you would like to update. 3. Rollup Helper Step 3) 1. Select Task as the Child Object with Name ID-Task.WhoId as the relationship. 2. Select Call Result (your custom one, not the standard) as the field on Task to use as a source for the rollup. 3. Select Text Separated By and New Line 4. Save and Run the rollup or run in real-time. 8. Create a Workflow Rule (Number of Calls to Obtain Discussion) 1. Object:  Contact 2. Evaluation Criteria:  created, and every time it's edited 3. Rule Criteria:  Run the rule if the formula evaluates to true: 1. Answer_and_Discussion__c  <> True 4. Immediate Workflow Action (Update “Number of Calls to Get Discussion”) 1. Specify New Field Value: Use a formula to set the new value. 1. Number_of_Calls__c 5. Save 9. Optional List View 1. Enter View Name (Attempted Contact No Discussion) 2. Specify Filter Criteria:  Answer and Discussion = False 3. Select Fields to Display 1. Add “Number of Calls” 2. Add “Call Results” (This should be the results of your Rollup Helper Text rollup. 4. Restrict Visibility 1. Select desired visibility. 5. Save Tags: [Contact](https://www.passagetechnology.com/rollup-helper-use-cases/topic/contact), [Rollup Helper](https://www.passagetechnology.com/rollup-helper-use-cases/topic/rollup-helper), [Task](https://www.passagetechnology.com/rollup-helper-use-cases/topic/task) | [** Populate a Date Field on Case with the Most Recent Task for Order Sent ](https://www.passagetechnology.com/rollup-helper-use-cases/populate-a-date-field-on-case-with-the-date-of-the-most-recent-task-for-order-sent) | [Rollup Helper Use Case Library](https://www.passagetechnology.com/rollup-helper-use-cases) | [ Rollup Helper for FinancialForce ** ](https://www.passagetechnology.com/rollup-helper-use-cases/rollup-helper-for-financialforce) | | --- | --- | --- | [ Optimize Sales Rep Reporting and Leaderboards in Salesforce ](https://www.passagetechnology.com/rollup-helper-use-cases/sales-rep-reporting) [ Rolling Up Marketing Cloud Account Engagement (Pardot) Activity ](https://www.passagetechnology.com/rollup-helper-use-cases/rolling-up-marketing-cloud-account-engagement-pardot-activity) [ Streamline Sales Pipeline ](https://www.passagetechnology.com/rollup-helper-use-cases/streamline-sales-pipeline) [ Creating Grandchild Rollups ](https://www.passagetechnology.com/rollup-helper-use-cases/creating-grandchild-rollups) [ Calculate the Number of Cases on a Salesforce Contact Record ](https://www.passagetechnology.com/rollup-helper-use-cases/number-of-cases-on-a-contact) [ Creating Account Hierarchy Rollups without Coding ](https://www.passagetechnology.com/rollup-helper-use-cases/account-hierarchy-rollup-without-code) [ Easily Create a Custom Last Activity (Task/Event) Date ](https://www.passagetechnology.com/rollup-helper-use-cases/last-activity-task-event-date) [ Roll-ups Using Formulas Rather than Static Criteria ](https://www.passagetechnology.com/rollup-helper-use-cases/roll-ups-using-formulas-rather-than-static-criteria) [ Identify The Primary Contact On An Account ](https://www.passagetechnology.com/rollup-helper-use-cases/identify-the-primary-contact-on-an-account) [ Opportunity Line Item Schedule Rollups ](https://www.passagetechnology.com/rollup-helper-use-cases/opportunity-line-item-schedule-rollups) © 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" : "Susan Harris", "url" : "https://www.passagetechnology.com/rollup-helper-use-cases/author/susan-harris" }, "dateModified" : "2026-04-21T19:27:06.409Z", "datePublished" : "2016-07-12T22:59:28.000Z", "headline" : "Number of Call Attempts to get a Discussion", "image" : [ "https://www.passagetechnology.com/hubfs/Imported_Blog_Media/List+View+-+Contact+Attempts-1.png" ], "mainEntityOfPage" : { "@id" : "https://www.passagetechnology.com/rollup-helper-use-cases/number-of-calls-attempts-to-get-a-discussion-and-filtered-sorted-list-view-for-reps", "@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" } } ```