How to use INDEX, MATCH and MAX to display newest form entry if cells match


Here's the setup

Sheet 1 Columns:

Created [standard] | Name | Form Entry

Sheet 2 Columns:

Name | Form Entry Display

MATCH Name:Name and take the Form Entry with the most recent Created i.e. the newest entry


Best Answer


  • mwiggins
    mwiggins ✭✭✭✭

    Works BETTER THAN EXPECTED - that Max Date column has the added benefit of showing us when certain names haven't entered anything yet because it comes up blank.

    Thank you Genevieve! Expertly crafted design,


  • Genevieve P.
    Genevieve P. Employee Admin

    So glad to hear that it works for you! You're very welcome - I'm happy to help. 🙂

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!