What criteria use to determine a "current user".
I have a report that surfaces information based on a current user filter. It is filtered on a contact column. The issue is, my users are all over the map with logon ids. We have two sets of emails in my company, internal and external. They all map to the same email client, so to the user it is transparent. In addition some users are built into our official company user container, and others are 'guests' even through they are employees. To add to the fun, some users have multiple identities under the same email address. One is FirstName LastName and the other is FirstName MiddleName LastName or sometimes it is Nickname LastName.
I get constant calls from users saying certain items are not on their dashboards - because the current user is not matching the contact.
So what exactly does smartsheet compare when it performs the current user filter. What must match for the current user to be true.
I wish there was a way to see this information for a user, even if I had to ask the user to retrieve it for me.
Help Article Resources
Check out the Formula Handbook template!