Report Visibility

Paul Newcome · 05/07/19

Hahaha. Maybe I can play it off by just saying we don't have to send out fresh published links every 30 days anymore and not tell them why the change. Hahahahaha.

No. Most of my coworkers are pretty easy going. I'll get a little bit of ribbing for sure, but nothing major.

Andrée Starå · 05/07/19

Haha!

Andrée Starå · 05/07/19

Haha! Good luck!

stephanie.blake67241 · 05/08/19

Can the people that have access to the report (in the process initially described) make edits to it? If not, is there a way to share a report (without sharing the underlying sheet) that the users have permissions to edit the report?

Mike Wilday · 05/08/19

No, they will not be able to make edits to the report. The only way to share an editable report with your clients is to share them on the original sheet as editors.

Andrée Starå · 05/08/19

If they need to edit, I'd recommend looking at the premium add-on called Dynamic View, because, with it, you can choose what who will see when.

https://www.smartsheet.com/product/dynamic-view

Would that work?

Best,

Andrée

stephanie.blake67241 · 05/08/19

Not ideal. Are there any other options?

Andrée Starå · 05/08/19

Do they need to edit everything on each row or just a few cells?

How many rows? Are rows added frequently?

Can you describe your process in more detail?

Best,

Andrée

Paul Newcome · 05/08/19

How much editing needs to be done? Are there consistent triggers?

Maybe sending update requests would work. You can limit what they see to the specific row that needs updated and only include specific columns, and they don't necessarily have to be shared to the sheet to submit a response to an Update Request.

Paul Newcome · 05/08/19

Looks like you beat me to it. Haha.

Andrée Starå · 05/08/19

Haha!

stephanie.blake67241 · 06/04/19

They only need to be able to change one column on the report - % complete. I want to avoid sharing the underlying sheet with them.

Paul Newcome · 06/04/19

I would suggest looking into update requests. You can limit what can be edited and what can be seen, and you don't have to share someone to a sheet for them to be able to respond to an update request.

stephanie.blake67241 · 06/04/19

Would it generate a separate request for each item? There are quite a few items on the report so I don't want to overcomplicate it - just want them to update it if/when they have made progress on an item.

stephanie.blake67241 · 06/04/19

Alternatively, can I hide certain rows on the underlying sheet if I do share it out?

Report Visibility

Comments

Categories