Sort by two fields in a project report

Question

Right now my project report is "custom sorted" by Project Status using a calculated field in a custom form so that current projects show on the top and complete projects show on the bottom. To do so, I used a calculated field in a custom form to number the statuses (the formula looks like this IF({status}="INI","1",IF({status}="APR","2",IF({status}="PLN","3",IF({status}="CUR","4",IF({status}="EXE","4",IF({status}="PKX","5",IF({status}="JPW","6"))))))). I then added a column for the calculated field to the report and followed the steps from this article to hide that column.

On top of the project status sorting, though... I would also like to make it so that of the current projects, they show in order of their planned completion date.

Anyone know of a way to achieve this?

KellieGardner · Accepted Answer

If you have a column for planned completion date on your report you should be able to sort through the native functionality.

However, if you want to sort by planned completion date without having it as a column (like you did with the above scenario) you should be able to add this to to another column to sort it by completion date without displaying it.

querysort=plannedCompletionDate
sortOrder=2
sortType=asc

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded