HELP!!! Max Collect for Dates

mbotte5

I utilize Smarthsheet to manage a hospital schedule. I need to find out the last time a staff member worked.

I have been playing around with Max Collect and constantly failing… #UNPARSEABLE

Things to note: The Primary column shows the name of the staffer multiple times with multiple different dates under the Date Worked column. I am looking for the formula to tell me the most recent time the staffer worked.

Here are my columns:

1st column - Primary Column = Names of the staffer (Text/Number formatting)

2nd column - Date worked = Dates that the staff member worked (Date Formatting)

3rd column - Last date worked = Where I am looking for the formula to output the last date (Date Formatting)

I have tried this… but honestly i am soooo so lost here.

=MAX(COLLECT([Date worked]:[Date worked, [Date worked]:[Date worked], ISDATE(@cell ), Primary Column:Primary Column, Primary Column@row))

I have created an example of the schedule below:

Larry

=MAX(COLLECT([Date Worked]:[Date Worked], [Primary Column]:[Primary Column], [Primary Column]@row))