Hello everyone,

I am creating a metric sheet to track the total hours, attendees, and person hours of meetings and would like to track it based on today's date.

In the example above, I would like to use TODAY() in the top row under the "Date" column. Then if the date in the rows below are in the past, return the corresponding values in columns "Total Running Hours", "Total Running Attendees", and "Total Running Person Hours" for the largest values. So if today is 02/06/24, then the top row should return the values listed for "Meeting 3" since it contains the largest values and there are multiple meetings that occurred on 01/30/24.

Thank you in advance.

-David