Ability to use a calculated column from a list report as a date field in a custom roadmap

Currently a calculated column in a list report can be formatted as a date and can be included in a custom roadmap in the "Shown on bars" and "Group bars by" section which is helpful.

However, the calculated column is not available to select as a date field (e.g. the bars start/end date), even though the calculated column is formatted as a date. It would be helpful to be able to have the bars start/end dates be driven by a calculated column formatted as a date as well.

Attach files

Enter a subject

Kim Bremer

Reply
| Jul 30, 2024

We are using Organizations to capture the projects and activities we do for various customers. For some teams/workspaces, they may have an entire Schedule representing some project we are doing for a customer. For other teams/workspaces, only the Activity is specific to the customer. (For example, a Schedule might be our Implementations team onboarding a customer to use one of our applications they do not currently use. An Activity might be our Infrastructure team moving a particular customer's server, where the activity is one of many in a larger Schedule to move a whole set of servers.) We would like to create a roadmap showing all work efforts by customer, and we can't do that without being able to select our calculated date field(s) for bars or milestones (the calculated field coalesces the Schedule date and Activity dates). We can make a pivot and show the work by quarters, but we would really love to be able to present this as a consolidated roadmap instead of a pivot.

0 reply Hide replies