FinancialForce - Sick time and Vacation time in Projects

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®.

Problem: We needed a field to show total hours tracked to Sick time and Vacation time Projects for a Resource.

This is easy to do with reports, but we needed fields to be populated so we could use them in a formula to calculate PTO balances.

Solution: Start by creating a rollup from the Timecard Header object to a field on the Contact object.

  • Create a rollup from the Timecard Header object to a field on the Contact object called "Sick Hours Tracked" and "Vacation Hours Tracked."

  • Send the sum of the Total Hours field on the Timecard for all Timecards that are for the Sick Time Project, and the Vacation Time Project, respectively.

FinancialForce - Master Project Budgeted Hours Allocated Rollup Helper Use Case Library FinancialForce - Resource Group Time Rollups