Report Current User
I have a Project sheet containing (amongst others) a Name and an Email column.
The Name column is defined as a dropdown - single select, the Email column as a Contactlist.
The Email column uses a formula to look up the email value in a sheet called "User Management".
This User Management sheet contains the columns User Name (=primary) and Email (=text/number).
I have made a (row) report in which the "Who?" section has "Email has Current User".
If I open the report, I can see the rows that are assigned to me.
If my colleague opens the report, he can't see any rows assigned to him.
Why doesn't it work for my colleague?