we have multiple workers on project need update progress in our spreadsheet on google docs , although google allows protect named ranges edit , how ensure users should not view particular cell\column or row. there hide feature not on per user basis.
in short need finer granularity on user can view, google allows view\edit @ entire spreadsheet level, not individual cell\row level. can google docs (scripts) tweaked accomplish this?
are there other free solutions accomplish apart googledocs?
may can prepare different sheets different users , use this on onopen function.....then later on collate information can use app script collate , view.....
