Select MAX(Modified Date) where name = Jane Doe

Options

Hi,

I have a contact log form that populates a sheet each time a user creates an entry. Each user creates several entries a day. In a separate sheet, I want to report the date that each user created their most recent entry. How would I go about that?

Best Answers

  • Cara North
    Cara North ✭✭
    Answer ✓
    Options

    Thank you Genevieve!

Answers

  • Cara North
    Cara North ✭✭
    Answer ✓
    Options

    Thank you Genevieve!

  • Genevieve P.
    Options

    No problem! Happy to help 😊

    Join us at Smartsheet ENGAGE 2024 🎉
    October 8 - 10, Seattle, WA | Register now