Trying to reference an inspection date collected from an inspection form archive sheet.

Options
kwillems
kwillems ✭✭
edited 05/09/23 in Formulas and Functions

I am stuck on a formula that I am trying to utilize in a roll up sheet to display the most recent inspection date that was submitted using a monthly inspection form.


=INDEX({Inspection Form Sheet Date Column}, MATCH(MAX({Inspection Form Sheet Date Column})))


I have tried several variations of this formula, any ideas what I am doing wrong?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!