RESOURCES‎ > ‎Example Rollups‎ > ‎

Lead Rollups

 Target:  Lead, Source: Task, Relationship: Who ID

    Rollup 1: Last Task Completed
                  Create a Text rollup from the Subject field of Task to the Last Task Completed field of Lead.
                  Filters: 
                        - Deleted will need to equal false
                        - Closed should equal true
                        - Add a sort by 'Activity Date' descending.  You will want to limit the number of results to 1.
  
    Rollup 2: Last Task Completed (Date)
                  Create a Max rollup from the Activity Date field of Task to the Last Task Completed Date field on Lead.
                  The filters should be the same as the above.

    Rollup 3: Next Task Planned
                  Create a Text rollup from the Subject field of Task to the Next Task Planned field of Lead.
                  Filters: 
                        -Deleted should equal false
                        -Closed should equal false
                        -Add two sorts - One by Created Date ascending, the other by Activity Date ascending.  
                         Limit the results to 1.

    Rollup 4: Next Task Planned (Date)
                  Create a Min rollup from the Activity Date field of Task to the Next Task Planned Date field of Lead.
                  Filters should be the same as Rollup 3: Next Task Planned.

    Rollup 5: Tasks Completed (Week)
                  Create a Sum rollup from the Task Count field of Task to the Tasks Completed field of Lead.
                  Filters:
                        -Deleted should equal false.
                        -Closed should equal true.
                        -Last Modified date should be equal to Last N Days: 7.
Comments