In my app (a social app where users create posts), I have a scorecard tab that shows various usage metrics for all the users. I’d like to include a metric indicating the time of last activity, by user. Ordinarily, I’d simply filter a timestamp field by user and find the max value. I cannot figure out a way to make this work with an ARRAYFORMULA. Any tips?
Here are the current formula and error message:
=arrayformula(max(filter([timestamp array in database sheet],[username array in database sheet]=[array of names in scorecard sheet])))
**Error** FILTER has mismatched range sizes. Expected row count: 46. column count: 1. Actual row count: 54, column count: 1.
The following formula gives the correct result for a single cell:
=max(filter([timestamp array in database sheet],[username array in database sheet]=[single name in scorecard sheet]))
This seems like it would be a common thing to do, so I hope there’s an easy solution that’s just in my blindspot. Apologies if the solution has been posted previously; I looked but couldn’t find it.