Formula for grouping in a timeline report

Question

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.

Thanks!

QuickBaseCoachD · Answer

I think that you were on the right track to combine the fields. I'm not quite what you want to Group by and what you want to just Sort By, but I'm guessing that you want to Group by the Phase and then sort on the deliverable, but both in your desired sequence.

So make a new field called [TimeLine Phase] with the formula

List(" ", Right("00" & totext([Phase Sort Order]),3), [Phase Name])

so that should read like 003-Dev of Future Services in Contract

and then similar for the [Timeline Deliverable]

List(" ", Right("00" & totext([Deliverable Sort Order]),3), [Deliverable Name])

You should then be able to Group by [TimeLine Phase] and sort by [TimeLine Deliverable]

Sign up

Login to the community