Collaboration with shared sheets
I need to share sheets with multiple users, some need to have editing ability, some just need to be able to view the sheets. But all users need the ability to collaborate with row and sheet comments. I am sharing multiple sheets, so I am trying to decide the best method for sharing. I have tried Dynamic View, Workapps, and Dashboard, here’s what I have found (pros and cons):
1. Dynamic View:
- Con - issue with Dynamic view is that you can not make sheet comments, only row comments.
- Pro – you can make sheet comments
- Con – you can make sheet comments with editor permission, which allows the user to also make changes to the sheets, which we do not want.
- Pro - sheet comments can be made, but you can’t edit the sheet.
I like the WorkApps function, but for my application, Dashboard seems to be the best option……am I missing something?