Identify MAX Date for each employee


I have created a list that tracks the number of days an employee is out. I need to identify the most recent absence. An employee can be on the list more than once. I would like to use the MAX function to identify the most recent absence for each employee by checking the box in Max Date. Is there a way to do that?

The unique identifier is the Emp Id.


Best Answer

  • Nick Korna
    Nick Korna ✭✭✭✭✭✭
    Answer ✓

    Hi @Ronald Anderson,

    You can absolutely do this:

    =IF(MAX(COLLECT([Leave End]:[Leave End], [Emp ID]:[Emp ID], [Emp ID]@row)) = [Leave End]@row, 1, 0)

    Hope this helps, but if I've misunderstood anything or you've any problems/questions then just let us know!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!