Find Latest Date for With a criteria in rows

Carloscmatos ✭✭
edited 01/02/22 in Formulas and Functions

I have a form that my field team inputs the action they make in customer, the same form is used for every customer, In Another sheet, I have the visit controle, and in this other sheet, I want to know the last visit my team made to each customer.

So I need to use a MAX formula for each specific customer.

The only solution I found was to user forms to enter the response in the upper rows, so my Vlookup brigs the latest entered visit, but it is not failure proof, so I would like the formula to look for the latest instead.



Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!