Customizing Colors in the Resource and Project Planners

To create custom fields and formulas:

1. In Setup, open the Objects page.
2. In the Custom Objects list, click the name of the object: Assignment, Resource Request or Project.
3. In the Custom Fields & Relationships list, click New to create a new field. A wizard opens.
4. Select Formula, and then click Next.
5. Enter a field label. The field name will be populated automatically.
6. Select Text as a formula return type, and then click Next.
7. Enter your formula, and then click Next.

   You must enter color names without spaces in formulas, but they are not case sensitive. Examples: LightBlue, lightgreen, lightRed. A formula will not work if you include spaces in the color name.

8. Complete the wizard settings.

Example formula for a Project object

IF( pse__Is_Billable__c , IF( pse__Opportunity__r.Amount > 1000001, "turquoise" ,"lightBlue") ,IF( ISPICKVAL(pse__Project_Type__c, "PTO"), "purple", " "))
This means:
If the project is marked as billable and the Amount field on the Opportunity record is:
1,000,001 or more (for any currency), the project summary bar is turquoise.
1,000,000 or less (for any currency), the project summary bar is light blue.
If the Project Type field is also set to PTO, the project summary bar is purple, but other project types don't affect the color.

Example formula for an Assignment object

IF( pse__Is_Billable__c , "lightYellow", "lightGreen")
This means:
If the assignment is marked as billable, the assignment bar is light yellow. For all other types of assignment, the assignment is light green.

The next step is to enable the colors to be used in the relevant planners for the functions that you created in the custom fields formulas.

To edit custom settings:

1. In Setup, open the Custom Settings page.
2. Click Manage for the relevant planner settings:
   Planners - Resource
   Planners - Project
3. Click Edit.
4. Enter the API names of the custom fields that you created for the color settings in the following fields:
   • For Resource Planner and Project Planner, complete the fields Assignment Color Field and Resource Request Color Field.
   • For Project Planner, also complete the field Project Summary Color Field.
5. Select the checkboxes for the colors that you have used in the formulas.
   

The next step is to add label definitions for the colors that you are using.

To enable the functionality to add label definitions:

1. In Setup, open Translation Workbench.
2. Click Enable.
3. Click Add.
4. Add English and any other required languages, and the users/translators for those languages, as needed. The users will be the only people who can edit the label definitions for the colors.

   To find these labels quickly, create a list view that contains a filter for 'LegendName'.

To add or update labels for colors used for assignments, resource requests and projects in the planners:

1. In Setup, open the Custom Labels page.
2. Select each label that corresponds to a color that you are using for the relevant planner:
   Project Planner labels:

   projplanner_PlannerScheduler_Beige_LegendName

   projplanner_PlannerScheduler_Light_Blue_LegendName

   projplanner_PlannerScheduler_Light_Green_LegendName

   projplanner_PlannerScheduler_Light_Red_LegendName

   projplanner_PlannerScheduler_Light_Yellow_LegendName

   projplanner_PlannerScheduler_Pink_LegendName

   projplanner_PlannerScheduler_Purple_LegendName

   projplanner_PlannerScheduler_Turquoise_LegendName

   Resource Planner labels:

   resplanner_PlannerScheduler_Beige_LegendName

   resplanner_PlannerScheduler_Light_Blue_LegendName

   resplanner_PlannerScheduler_Light_Green_LegendName

   resplanner_PlannerScheduler_Light_Red_LegendName

   resplanner_PlannerScheduler_Light_Yellow_LegendName

   resplanner_PlannerScheduler_Pink_LegendName

   resplanner_PlannerScheduler_Purple_LegendName

   resplanner_PlannerScheduler_Turquoise_LegendName

3. In the Local Translations/Overrides section, click New Local Translations/Overrides if no translation exists, or Edit for an existing translation. The Translation Edit page opens.
4. If new, select the language, and then enter the text to be used for the label.

   If editing, enter the text to be used for the label.

5. Click Save.
6. Repeat steps 3-5 to add other labels.

The label definitions associated with the colors are displayed in a color legend for the relevant planner.