Latest Date Formula

Options

Hi

I want to find the latest date a review was done on a file number. Multiple reviews could have been done on the same file so, I only want the latest date. I have used:

=INDEX(MAX({01.SHEET: File Review Range 1}, MATCH([Matter Number]@row, {01.SHEET: File Review Range 2})), 0)

as I am referencing the File Review sheet but it comes back with an #INVALID DATE, I'm assuming it's because I've got my MAX in the wrong place, or I can't use MAX in my nested formula. Any ideas?

TIA

Cheryl

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!