Trying to find the max value (last payroll Date) from a list with multiple records for an employee

Bert Hoffbeck
Bert Hoffbeck ✭✭✭✭

I'm not sure how to isolate the largest/latest date from a sheet that has multiple records with various pay dates for a single individual. The sheet has about years worth of entries for the company.

For example, Employee #2 has worked 7 different weeks in the current year on multiple projects, and I want to know the most recent (i.e. max) date that they worked and pull this information into another sheet using the Index Match function, but I need a way to have a column in the source sheet that will show that max value (date).

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!