PMO Template where I need a portfolio report of all current project statuses by most recent date
Hello! I would like to keep a continuous project status update for each project in an individual workspace, but only report the most recent one back at the portfolio level. I have a separate status update sheet in the project workspace (A). If I just link the column, it obviously pulls all the updates.(B)
- How can I extract to the project metadata first by latest date? My attempts have me getting all statuses and not just most recent.
- Should I not be trying to put it into the project metadata to then load into the portfolio metadata? Should it be a separate report first?
- What is the formula for extract by latest date?
Thanks so much, looking for any ideas :)
Help Article Resources
Check out the Formula Handbook template!