- Report showing sheets I've shared and to whom
Our team is fulling engaged in using - and sharing - Smartsheets. The reporting capabilities are terrific. But I am trying to locate (unsuccessfully) if there is a way to run a report on all the sheets I have shared and, specifically, to whom I have shared all those sheets. Rather than clicking on each sheet separately and…
- Should I have a PM Lite Smartsheet? A One Pager?
This time last week, my CIO asked me to look into Smartsheet. One week later I have a beta version of a project template containing 6 sheets, 3 reports, and one dashboard. I was surprised how easy it was to develop a pretty solid solution in such short amount of time. The beta version of my project template should work for…
- Using smartsheet for grant writing
I am a grant writer at a nonprofit and my development team uses smartsheet. I am at the beginning stages of using smartsheet and want to use it for EVERYTHING related to my grant writing (calendar, deadline tracker/notifier, links to emails, links to webpages, task list, grant applications, anything else you can think…
- Anonymous sharing to users without publishing
I'm looking for a workaround for a problem with sharing a sheet and its attachments with several non-licensed users. The situation is that whilst the collaboration features in Smartsheet are great when we are working within our team, they are problematic when it comes to sharing the information. We need to give several new…
- Can I lock columns, and give specific edit access per column?
Hi I currently have a team of 5 people who will be updating a smartsheet every month. Each person has to update their own specific column with data, is there a way to grant access to a person for that specific column so other people can't over write it? I know I can lock rows and columns and grant access, but it seems that…
- Limit View within a Sheet (using Web Forms)
Hello, New to Smartsheet. We would like to utilize a web form to allow customers to place orders/requests whereby the web form would populate the smartsheet for ONLY OUR INTERNAL visibilty/tracking of all requests combined. Currently, when I test this I am brought back into the sheet where I can see ALL requests. Does…
- users feel intimidated by Smartsheet
I collaborate with many people who have no PM experience and/or prefer memo-style information over cell-based. Some people feel overwhelmed by the tool so they send emails rather than update Smartsheet. Beyond the training and show-me sessions we already do, how might I help people embrace Smartsheet? Do you know of ways…
- Using Smartsheet data to populate project documents
I looking for opportunities to streamline the production of project updates / documentation by trying work out the best way to use data already captured in various smartsheets to populate project updates to our product development steering group. I presume there is no function in Smartsheets that facilitates the output of…
- interconnecting several sheets (to manage employee action items)
有可能分享2或更多terconnected sheets such that there is a parent sheet and multiple child sheets and the parent rolls up the info on the child sheets, allowing any changes on either the parent or child shows up for the other users? The key is that this needs to be bi-directional like normal smartsheet…
- Filtering
What's the best way to show just the rows in a sheet that are assigned to me? If I apply a filter to the column it affects the sheet for everyone else, right?