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

Anyone getting JIRA API errors using the connector?
We are using the Jira/Smartsheets connector and got this error: Invalid response from JIRA. statusCode: 410, reasonPhrase: Gone The requested API has been removed. Please migrate to the /rest/api/3/search/jql API. A full migration guideline is available at Looks like the connector needs to be updated. Anyone know anything…
Dirty save - #BLOCKED/Invalid Value issue when using integration until manually save the sheet
Hello everyone, We’re facing a critical issue in one of our Reports. We use integration and it adds values to the sheets. The corrected values don't seem to auto-save. Formulas in sheets first show #BLOCKED/Invalid Value, then if we refresh the sheet - it updates to the correct numbers. The save button is active even…
Smartsheet for Google Drive doesn't seem to be available anymore
Trying to access Smartsheet for Google Drive and it seems it's not available anymore: https://workspace.google.com/marketplace/app/app/46145466229 Also the app is not listed when searching on Google Marketplace.