I manage a Project Plan application. There are three tables - Project Phases, Deliverables and Tasks. Phases have Deliverables, Deliverables have Tasks.
In order to make the records show up in the appropriate order I have a numerical field named Sort Order. This works great for Grouping and Sorting in table reports in the correct chronological order.
I am trying to build a Timeline report now, and when I Group by Phase Sort Order, Phase Name, Deliverable Sort Order, Deliverable Name, the grouping headers take up too don't look good/are confusing.
I tried a few different formulas combining these values but it wouldn't sort numerically after that.
I attached an image of how it looks now. Ideally, all four values will show up on one line, and sort numerically based off the Phase and Deliverable Sort Order numerical fields.