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

(Johann Harshman) #1

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?

(Tony Fader) #2

@Johann_Harshman Can you try MAXROW(“Your Table Name”, “Your Date column”)