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!