Segmented Sheet Permissions
I have a sheet which is a cradle to grave view of the lifespan of a deal.
The problem is each of the three departments have a different permission level.
In the diagram below:
Buyers have Modify rights to Columns Pri,1,2 but cant see Columns 3,4,5,6
Operations have Modify rights to Pri,1,2,3,4 but cant see 5,6
Finance Modify to All.
There are alot more columns and groups, but this simplistic view will convey my problem.
This would be easy if smartsheet let me set permissions on a column level, but another plan will have to be made since it doesnt.
I initially planned to use a report for buyers and a separate report for operations since it allows bidirectional editing of the data and i can restrict the columns in each view - this would work perfectly for me, but the problem there is the data does not show up in the report unless those users accounts are added to the source sheet as editors which we cant do since they are not privy to that full sheet. When they log in it shows the spreadsheet in their list and they can open it.
i tried publishing the report, but the link is either open to the world or only locked down to the people "in your account" which means a buyer can use the link to view a operations report which we cant have. also it is read only if i remember correctly.
I also tried to use multiple sheets where Buyers had a sheet and their columns were inserted via linked cells into a spreadsheet for operations which included their own columns and all those cells were linked cells into the finance sheet which also included their columns. this worked fine in theory, but we lose the bidirectional editing capability since you cant edit a linked cell.
similarly tried to use vlookups between the sheets but also lose the bi directional editing.
I also tried to pull a report from these individual sheets but cant get around having duplicate data (multiple rows for one deal)
Please can someone help, I have researched as much as i can to try get round this and am stumped.🤦♂️