Skip to main content
All CollectionsManage Your ReportsProject reports
How can I see all projects that were delivered in a year?
How can I see all projects that were delivered in a year?

Here's how you can use the project list Custom Columns and the download to quickly see all projects that were delivered in a year.

Colin Connor avatar
Written by Colin Connor
Updated over 2 months ago

From your project list, first ensure you're viewing 'All Projects'.

Next, add in your date range using the Specific Dates filter.

Then, add in your required Custom Columns (For example, Logistics Start, Contract Total/ Tax, etc).

After, filter your projects by your desired stats (all, just signed, etc).

Now select these projects and download them to an excel document.

Let's clean up this document (FYI, I'm using Google Sheets, as I find this the easiest to use)

Remove the top two rows. We won't be needing those.

Next, freeze the top row. This will make it easy as you scroll through this list.

Then, let's sort this project by Logistics Start to order from the earliest project to the latest.

First, select the column with Logistics Start.
Then, select to format that column as a Date.

Next, select all the document.

Then, select to sort this range.

Finally, sort this range by Logistics Start Date.

This will then show you all projects, from the earliest project to the most recent, with your requested columns.

Did this answer your question?