Is it possible to modify the settings on the planning console duration field from days to weeks?

[Alejandra1]

Hi everyone! 

I was wondering if it was possible to modify the settings on the planning console to be able to indicate weeks or months at the duration field instead of only days (as I have it configured right now). How can I make the change if this is possible? 

Thanks in advance! 

[Rajesh_Singh]

@Alejandra1 

The ServiceNow PPM Planning Console does not have a built-in feature to display task duration in weeks or months directly. However, you can still display the duration in weeks or months using a workaround.

To achieve this, you can create a custom calculated field on the Planned Task table (pm_project_task) that calculates the duration in weeks or months. Here's how you can do this:

1. Navigate to "System Definition" > "Tables" in ServiceNow.

2. Search for the "pm_project_task" table and open it.

3. In the "Columns" tab, click on "New" to create a new custom field.

4. Set the "Type" of the new field to "Formula" and give it a "Label" like "Duration in Weeks" or "Duration in Months."

5. In the "Formula" field, enter an expression to calculate the duration in weeks or months based on the "Planned Start Date" and "Planned End Date" fields. For example:

   • To calculate the duration in weeks, use the following formula: FLOOR((planned_end_date - planned_start_date) / 7)

   • To calculate the duration in months, use the following formula: FLOOR((planned_end_date - planned_start_date) / 30.44)

6. Save the new custom field.

After creating the custom field, you can add it to your Planning Console's task list:

1. Navigate to the Planning Console of your project.
2. Click on the "hamburger" menu (three horizontal lines) in the upper left corner of the task list and select "Configure" > "List Layout."
3. In the "List Layout" configuration, add your custom "Duration in Weeks" or "Duration in Months" field to the "Selected" column.
4. Save the changes and close the "List Layout" configuration.