Generate report to show project timelines in number

We need to provide reports to management showing our Time to Market lead-time. I like the Portfolio feature, but it doesn’t give me the total number of week or months that a project takes from start to end.
Is there any way to get that data?
Thanks,
Jenny

@jenny_cadwallader if each project has a due date that represents when it is “Market Ready” then you can do a couple things through the Google Sheets Portfolio Integration.

With this integration you can write a formula subtracting TODAY() from the end date of each project where this would be “Days to Market”. If each project had a Start Date you could calculate “Time since Inception” and then subtract the Due Date from the Start Date for a complete lead time.

2 Likes