A file was shared with me (with limited permissions), the owner set a filter to limit what can be seen of the file. However, when I go to view the spreadsheet I only see blank cells. I have no way of turning off the filter. What am I doing wrong?
Do you know if the owner of the sheet set it up as a report? If it is a report and you cannot see the data, it's because you don't have permissions to see the underlying sheet.
The solution I have found to this is for me (as the owner) to create the report, then put the report on a Dashboard, and share the dashboard with the person. That way, I don't have to share the entire source sheet with them, but they can see the filtered data I want them to see.
Hope this helps!
That worked, thank you for the help!
Fantastic! Glad it worked for you.
I have many many sheets where column names are the same but data types are different (ex: some "Assigned to" columns are text/numbers and some are contact list, some "Project Name" columns are text/numbers, and some are dropdown list.) The choices in value type are driven by the many teams specific needs. This creates…
Is it possible to format a singular cell in a sheet to total the above numbers add in each cell of the column.
When managing a PMO. is it considered a best practice to establish an individual workspace for each project? If this is advisable, is there a method for setting up an automated recurring backup for all projects without having to do them individually?
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.