Pulling the most recent entry into a report

Celia Gust

Hi, I want to create a report that will have the most recent Project Health from a group of Project Update sheets. On each Project Update sheet, I created a help column to show the Max date = 1. I think this will work to get to the most recent update with the most recent Project Health, but I don't know how to construct the formula. I would like to create a summary sheet formula for each Project Update sheet that can then be used on the associated project dashboard and also in a roll up report to be used on a portfolio dashboard showing all of the projects with their most recent Project Health.

I want it to say: If the Most Recent Update = 1, then pull the Project Health from that line. In this case, it would pull the Project Health from 12/4/24.

Thanks ahead of time!

Paul Newcome

Have you looked into using a row report instead of a sheet with formulas?

Paul Newcome

Have you looked into using a row report instead of a sheet with formulas?

Celia Gust

I tried that, but I'm not sure how to filter the results to only pull the most recent update. I thought maybe adding it to a summary sheet would be easier.