Returning Max Date from Another Sheet with Conditions



I am trying to gather the max date from a row on another sheet if that row has a matching cell to one on the current sheet. Below is a screenshot of the current sheet. I am trying to fill the Last Action Date cell if the Originating WO# cell matches the one on the other sheet.

Other sheet:

I would like the formula to choose the latest date (from between Sent, Date Conf, Shipped, Received) on the other sheet if the WO numbers match.

I've tried a few combinations of Index, Match, Max, and Collect but can't seem to get the right formula.

Thank you!

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!