--- title: Last Task Completed Subject on Contact with Hyperlink | Rollup Helper Use Case Library description: Increase sales productivity in Salesforce with Rollup Helper. See the last task's subject on contact records, with a link for contact list views & reports. image: https://www.passagetechnology.com/hubfs/Imported_Blog_Media/Hyperlink+Rollup-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) # Last Task Completed Subject on Contact with Hyperlink [![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: To increase sales productivity, I want to see the last task's subject on contact records as well as a hyperlink so it can be used in contact list views and reports.    ![Report on Contact Recent Activities](https://www.passagetechnology.com/hubfs/Imported_Blog_Media/Hyperlink+Rollup-1.png) ![List of Contact Last Activities](https://www.passagetechnology.com/hubfs/Imported_Blog_Media/Contact+Related+List-1.png) ## Solution: Create 3 Fields on Contact 1. Text Field:  Last Task Completed 2. Text Field:  Last Task Completed ID 3. URL Field:  Last Task Completed Link   Rollup the Subject of the last task completed.   1. Select Destination Object:  Contact 2. Select Target Field:  Last Task Completed 3. Select Source Field 1. Which Object:  Task 2. Select Relationship:  Name ID-Task.WhoId 3. Which Field:  Subject 4. Select Type:  Text 4. Create New Filter (Most Recent Completed) 1. Step 1) Enter Filter Name, Limit to 1 Record 2. Step 2) Specify Sort Order 1. Due Date Only 2. Descending Order 3. Step 3) Specify Filter Criteria 1. isDeleted = false (default) 2. Status = Completed 5. Save and Run the rollup.   Rollup the ID of the last task completed.   1. Select Destination Object:  Contact 2. Select Target Field:  Last Task Completed ID 3. Select Source Field 1. Which Object:  Task 2. Select Relationship:  Name ID-Task.WhoId 3. Which Field:  Activity ID 4. Select Type:  Text 4. Select Filter:  Most Recent Completed 5. Save and Run the rollup.   Workflow Field Update for Last Task Completed Link (Setup>Create>Workflow & Approvals>Workflow Rules>New Rule)   1. Object:  Contact 2. Rule Name:  Last Task URL 3. Evaluation Criteria:  created, and every time it’s edited 4. Rule Criteria:  Contact: Last Task not equal to Null 5. Immediate Workflow Action:  Field Update (Last Task Completed Link) 1. Name:  Task URL 2. Unique Name:  Task_URL 3. Re-evaluate Workflow Rules after Field Change = True 6. Specify New Field Value 1. Use a formula to set the new value 1. 'https://slightning1-dev-ed.my.salesforce.com/' + Task_ID__c (Use the URL from your org.)   Create new Contact Reports and List Views.  You can customize your report and list views in any desired manner.   For further assistance with this use case or to learn more about Rollup Helper, please schedule a [One on One Demo](https://www.passagetechnology.com/any-product-one-on-one).   **Need help?** [![Schedule a one-on-one demo](https://no-cache.hubspot.com/cta/default/4130736/fbae864a-7cf4-44e6-93ef-9069a57d082e.png)](https://cta-redirect.hubspot.com/cta/redirect/4130736/fbae864a-7cf4-44e6-93ef-9069a57d082e) Tags: [Contact](https://www.passagetechnology.com/rollup-helper-use-cases/topic/contact), [Sales Productivity](https://www.passagetechnology.com/rollup-helper-use-cases/topic/sales-productivity), [Activity Monitoring](https://www.passagetechnology.com/rollup-helper-use-cases/topic/activity-monitoring), [Contact Management](https://www.passagetechnology.com/rollup-helper-use-cases/topic/contact-management), [Rollup Helper](https://www.passagetechnology.com/rollup-helper-use-cases/topic/rollup-helper), [Task](https://www.passagetechnology.com/rollup-helper-use-cases/topic/task) | [** Rollup Helper for FinancialForce ](https://www.passagetechnology.com/rollup-helper-use-cases/rollup-helper-for-financialforce) | [Rollup Helper Use Case Library](https://www.passagetechnology.com/rollup-helper-use-cases) | [ Calculate Agent Caseload Utilization % in Salesforce ** ](https://www.passagetechnology.com/rollup-helper-use-cases/calculate-agent-caseload-utilization-in-salesforce) | | --- | --- | --- | [ 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:25:21.184Z", "datePublished" : "2016-11-02T13:40:02.000Z", "headline" : "Last Task Completed Subject on Contact with Hyperlink", "image" : [ "https://www.passagetechnology.com/hubfs/Imported_Blog_Media/Hyperlink+Rollup-1.png" ], "mainEntityOfPage" : { "@id" : "https://www.passagetechnology.com/rollup-helper-use-cases/last-task-completed-subject-on-contact-with-hyperlink", "@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" } } ```