How can I retrieve the most recent date based on two criterias?

Options

How can I retrieve the most recent date based on two criterias?

Here's the current formula that I am using
=MAX(INDEX((Message_List!A:A="Andrew")*(Message_List!D:D="New"), Message_List!C:C,))

it's not returning an error but it's also not returning the correct cell

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!