Filters for different users

Im a new smartsheet user and need some help!

we have a sheet with a work schedule. There are address/information columns and then columns of dates for various contractors.

We would like to give view only access to subcontractors but only want them to see their own columns. We want them to be able to access this information through the app.

I tried a report but the viewer can see all the information as they have to be a viewer on the sheet as well as the report we need a “live” system so doing a PDF report isn’t an option for us

I’ve seen suggestions for using AppSheet but wouldn’t have a clue how to do this!

thanks

paul

Find more posts tagged with

Construction

Sharing and Collaboration

Integrations

Comments

Shaine Greenwood

Hi Paul,

There currently isn't a way to only share specific rows, columns, or individual cells in a sheet to specific people.

With that being said, you might consider creating reports for your specific subcontractors—then publishing it and sending them the publish link.

A couple of things to keep in mind when publishing a report:

Published reports are live
The published version of the report is read-only; your subcontractors won't be able to edit it from their end unless they're also shared to the report from Smartsheet

More info on this is available in the help center: https://help.smartsheet.com/articles/522078-publishing-smartsheet-items#publishreports

Sign in to join the conversation!

Quick Links

Trending discussions

Dynamic View - Loading Issues
Is anyone experiencing issues with Dynamic View showing a bunch of blank flashing rows when loading instead of the normal revolving circle that says loading? As a result, it shows the flashing rows for a bit and then nothing to display despite the fact it should be displaying certain data for users. We have shared groups…
DocuSign Status Column Not Updating Consistently (Non-Mapping Issue)
Hi Smartsheet Community, We’re hoping to tap into the collective expertise here about a DocuSign integration issue. Here’s our setup: •All information is collected via a Smartsheet form. •Based on certain cell values, one of several DocuSign integrations is triggered. •Documents are generated and routed correctly in…
DataMesh: What if the lookup value column is a formula?
I have a sheet to track travel, which includes a Start Location column and End Location column, and a third "Start - End" column which contains a formula that combines the first two columns. I've done this so that I can reference another sheet, which has the estimated cost from Location A to B, using DataMesh. However,…