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

Junariez

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

Paul Newcome

This looks like an Excel formula. Are you trying to get this to work in Smartsheet, or are you actually working in Excel?