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

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?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!