I don't want to transfer ownership of everything over to a single user before reviewing what they are the Owner of.....Workspaces, Folders, Sheets, etc...
Hi @Greg Gibbons & @Susan B Peck
If you're a System Admin, in User Management you can download a Sheet Access Report; this generates an Excel file listing the names of sheets accessible to the user, including what they own! (See here).
Hope this helps!
@Greg Gibbons - great question! I've had this come up recently, as well. It would be a great addition to have this information as part of the new Admin Center, kind of like a Properties for each user.
@Genevieve P Thanks for the answer. Yes, I'm familiar with the Sheet Access report. It's cumbersome to request, receive, and use. Years ago, files were sent directly by email and not zipped up. Smartsheet added a step of complexity to the process for some (probably good) reason, but it has made it more difficult for us Sys Admins.
It just seems with the new UI for the Admin Center, adding more information readily available in the Admin Center would be helpful. So far, I'm not impressed with the new Admin Center. Not any really new features that help me do my job and the lack of simple UX features like keeping the side menu visible all the time make it clunky to use. I'm always happy when the old Admin window pops up again.
Yes, I've provided this feedback on the new Admin Center UX several times but I don't think the product team reads any of it. Just the experience of a Smartsheet user since 2011. Smartsheet used to listen to us more.
It's good to hear your experience - I'm glad you've provided this feedback through the new Admin Center as these sort of user experience examples are exactly what the Product Team is looking to hear from System Admins. There are a lot of variables they need to consider before creating new features, and it's not always possible, but they do read and appreciate your input.
In the meantime, the Sheet Access report should provide the data Greg is looking for. Greg, let us know if you have other questions before transferring these items over!
Thanks, Genevieve. You are the best about responding. I'm glad to know the product teams look at feedback and I understand the difficulty of programming. Pinning the menu shouldn't be too hard, since it is done on every Smartsheet. I guess that's why it's such a surprise that the same UX isn't carried over to the Admin Center. Just an observation from someone who keeps multiple SS tabs open every single day to get stuff done.
Thank you both for your quick replies. I was able to run the report and find the information that I was looking for.
It is a rather clunky way to get there. It would be nice to view this information without downloading all of the details on the report, sorting, filtering.... I like Susan's suggestion of a User Properties type of selection from the Admin Center. I'm sure like most of the System Admins here, my time in Smartsheet is only a portion of my day...every little bit of saved time is greatly appreciated.
Thanks So Much, Greg
Hello! I copied a form I had made for a similar event I am working on now. I made minor adjustments to the form to match the needs of the event. I distributed the form for people to complete, so the form is active, but the data is not populating onto my Smartsheet. Please advise. I would prefer not to have people redo the…
Hello. Trying to make a quick attendance tracker for a meeting. I got conditional formatting to change the cell color when its checked vs unchecked. However I cannot seem to find a way to get the rule to apply to multiple columns on a per column basis. I need a way to copy what I have for column 3 and apply it to all…
Hey Smart Heads, I have another question about our beloved topic of formulas. Background: I have a autogerated column with row created date. In the file, rows are added in 2 ways: In bulk, by senior auditor Ad-hock by auditor I would like to diferentiate these two types of inflow. I came up with an idea of finding…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.