Can I filter a table by user email?
I have a sheet showing business leads and details and the sales rep (by login email). Can I create a table to show those details and only allow each rep to see their own lead details? I thought I could accomplish this by creating a filter on the table where the email address equals "Session.getActiveUser().getEmail()". That didn't work (or I suppose I wouldn't be posting this). Any suggestions? It would be great to deploy one datastudio that all the reps could use to get the reports that are relevant to them (filter by active user email). Thanks in advance for any help.
Re: Can I filter a table by user email?
make one report that all the reps could use and just see their results.
Maybe Google will add that functionality?
*Andrew Conway* P.Eng.
*Mobile: 416-990-2446 <416-990-2446>*
Please take our Customer Satisfaction Survey (only 5 questions)