As an operations manager, I want to be able to easily see the date of the most recent task with a specific subject (Order Sent) that has been completed on a Case.
Create a custom date field on Case (Order Sent)
Create a rollup
Rollup Helper Step 1) Select Case as the object to roll up to.
Rollup Helper Step 2) Select the field on Case that you would like to update (Order Sent).
Rollup Helper Step 3)
Select Task as the child object with the Task.WhatId for the relationship.
Select Due Date Only as the field to use as a source for your rollup
Select Type: Maximum
Create a filter
Filter Step 1) Keep the “Limit to” 1 record.
Filter Step 2) Keep the Sort order on Descending for Due Date Only
Filter Step 3)
Subject contains Order Sent
Status equals Completed
Save the filter
Save and Run the rollup!