Roll up report where Multiple vendors cannot access report or underlying sheets?

GetITDone

If I create 1 sheet per external company, so that each vendor can update their own sheets, can I create a roll up report combining all the sheets that only our internal staff can view and all the external companies cannot see any other competitors sheets?

This is a skills/certification sheet so we know what skills are vendors have.

(Vendors are all competitors)

Andrée Starå

Hi,

Yes, as long as each company only have access to their own sheet it will work.

Also, a solution that would be perfect for this use-case is the premium add-on, Dynamic View. Is that an option?

More info: 

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

I hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi,

Yes, as long as each company only have access to their own sheet it will work.

Also, a solution that would be perfect for this use-case is the premium add-on, Dynamic View. Is that an option?

More info: 

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

I hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

GetITDone

Hello and thanks kindly for the quick response. I have already proposed Dynamic View but that is not an option at this time.

Andrée Starå

Happy to help!

Then you can go with creating one sheet per company and then have a report to see everything together.

That will also work. More work, but it will work.