When I use Max(Table[Date]), It returns the m...

[Johann_Harshman]

When I use Max(Table[Date]), It returns the most recent date correctly…

but I want to pull the date for a project associated with a specific employee with (Maxrow(table, date, useremail() = employee email) + a ref column - as shown in the given appsheet example code.

When I use Maxrow(Table, Date) It says it cannot be parsed due to #VALUE!. What does this mean and how can I fix it?