-
Smartsheet reports created from 1 sheet for updating, need to allow users to set their own filters
Hi, I have a Master Smartsheet, that I created 20 reports from. Each report is a filter for each user and shows just the columns that need to be updated. As we add add more data by phase in the master sheet, each user wants to filter the data by phase as they are working through their tasks. Edit permission does not allow…
-
Permissions on a Sheet
I have several users (who have paid accounts in Smartsheet, but are not on my paid account) that were able to access the sheet. When I upgraded my account from a non-paid license to a paid license, all of their permissions were changed to "View Only". Even though they have edit permissions in my view, when they login, they…
-
Unable to move Cell Links from Control Center due to insufficient permissions
Hello, We used Control Center to create project plans for our projects. We have an Intake Sheet, the Project Plan, and the Summary Sheet. The value from the Intake Sheet is linked to the Project Plan Profile Data. The value from the Project Plan Profile Data is linked to the Summary Sheet. I am trying to move the cell link…
-
Permissions -- Filter Sheet but No Edit Privileges
I have collaborators that need/want to be able to filter data on a grid sheet. We need to ensure there are no editing permissions. Is there a setting that allows this? Thank you.
-
Sharing a report without Sharing the Source Sheet
I saw this question has been answered several times but I am hoping that Smartsheet has introduced an enhancement. Is there a way to share a report without sharing the Source Sheet. I need the user to be able to edit/ update the report however there is sensitive information on the source sheet that will be filtered on the…
-
I cannot give editing permissions to my colaborators
I'm having trouble with giving permissions to my colaborators to edit my sheet. I give the permissions with the top-right button in the sheet (no trouble with that), but when my colaborators log-in with their personal accounts to edit the sheet, they find only visualization permissions. I've tried everything, from changing…
-
Sharing and Publishing Dashboards and underlying objects
Hi, Hoping the community can help with this one. I have a portfolio-level dashboard with a number of widgets. The primary widget is a report widget. Each row in the report represents a project in the portfolio and one of the columns is for a link to the project-level dashboard. The project-level dashboards themselves have…
-
How do i allow a user to see data on a report, without giving them access to the Master Data sheet
Hello, I have a form that feeds data into a master sheet/grid. I have am automation that separates the data by teams. I have a specific report that that has the information pulled in from the main page and i tried to give somebody access to just that sheet but they cant view any of the data. The only way they saw any of…
-
Why can't I grant Edit access to a report in a WorkApp?
I have several identical WorkApps (each for a different department). I created a new one (copied all of the content from a previous one that is working) but with this new one I am not given the option to allow Edit access to a report within the app. The option just doesn't show up, I only get Viewer or Hidden. Any ideas…
-
View Only Access to Subset of Columns
I'm looking for way to allow a restricted view (sub set of columns) to and an external organization (I've set up a View Only user group). 1st try: Create a report with just the columns - FAIL. I still need to grant the view only permission to the source sheet 2nd: Create a 'query sheet' that 'VLOOKUPS' just the columns -…