MAXIFs Alternative?

I have a google form that updates the prices of materials. On google sheets to display the most updated price of the material I have a Newest Entry Column =MAXIFS(Timestamp:range, Material cell) then in the material price columns I have an Index/Match formula to display the most recent entry for that material. 

I would like to do the same thing for my mirror sheet on smartsheet, but there is no MAXIFs formula. How can I achieve the same result? Max date of all the entries that match the entry on the line I am working on.

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!