Pull Most Recent Invoice Data for An Account Using INDEX/MATCH/VLOOKUP/MAX (Or Other)

Greetings!


Our team uses a Smartsheet to track monthly invoices for each client. Each invoice date is listed separately for each client (see attached). We are interested in populating in another Smartsheet the date of the last invoice. For some clients, it might be 02/28/2022, for others 12/31/2021, or other dates for other clients.

Is there a formula in Smartsheet that can pull for each unique client its last invoice date, even if the client name is listed multiple times?

Thank you,

John

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!