Sheet Summary formula to pull value of cell based on latest date

Nate H

Hello Community -

I've scoured the forum and can't find a solution for my particular situation. I have a sheet where I want a summary field to pull in the value in the CL Readmit VAR column based on the most recent date in the Modified column. The sheet will continue to populate rows from a form so I need the summary field to grab the latest data.

Mike TV

@Nate H

Try this:

=INDEX(COLLECT([CL Readmit VAR]:[CL Readmit VAR], Modified:Modified, MAX(Modified:Modified)), 1)

Mike TV

@Nate H

Try this:

=INDEX(COLLECT([CL Readmit VAR]:[CL Readmit VAR], Modified:Modified, MAX(Modified:Modified)), 1)

Mike TV

@Nate H

One problem I foresee which might happen is if you have a form submission on the same day it's going to grab the first one and not the 2nd one. It's evaluating the date not the date and time, I think.

Mike TV

@Nate H

Actually, I think it does look at the time as well. I just tested it and it looks to be doing it right.

Nate H

Brilliant, sir! Thank you.