Export list of all users a smartsheet was "shared to"
I have been provided an export a list of who the smartsheet has been shared with an their particular permission such as view or editor. This is great because it provides that list of email addresses associated, however, it does not seem to provide the users name. Is there a way to export this information and include the users name (as well as their email address)?
Thanks in advance
Best Answer
-
I don't believe there is. The Sheet Access report goes by user login only. User name is not even a field that is filled out when a sheet it shared to someone, and shared users don't always put one when they create a free account.
Regards,
Jeff Reisman, IT Business Analyst & Project Coordinator, Mitsubishi Electric Trane US
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
Answers
-
I don't believe there is. The Sheet Access report goes by user login only. User name is not even a field that is filled out when a sheet it shared to someone, and shared users don't always put one when they create a free account.
Regards,
Jeff Reisman, IT Business Analyst & Project Coordinator, Mitsubishi Electric Trane US
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
-
Jeff Reisman, thank you.
Help Article Resources
Categories
Check out the Formula Handbook template!