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?

Kind regards


Best Answer

  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭
    Answer ✓

    I can see the issue. You need to make sure your User Management sheet for the email is also a contact column. Smartsheet isn't able to convert the text/number data into the contact column data. Does that make sense?