Hiding a column from certain users but other users can see and interact with that column?
I have a sheet that we use internally to monitor public park facilities. None of the columns contain any sensitive information so we share the sheet with a 3rd party organisation who's staff help keep the content updated.
Due to column one containing the discussion feature for row level communication, we are very conscious that all eyes can see this and there's no way to restrict usage of the discussion feature between users (I think??!!). We therefore can't put any comments that are internal and sensitive in the comments section (because our 3rd party shared colleagues can see them). We therefore had the idea of creating a column called 'internal notes' and for this column to be hidden from our 3rd party users but our internal team can edit and write comments in it. We'd just enter text and could use the cell history feature to see previous comments.
Two questions therefore please:
1 - Is there a way to keep a certain discussion private in the column one discussions feature (eg I somehow tag people in the posts and nobody else beyond those tagged people can see the discussion item).
2 - Assuming 1 is not possible, can we create a column and have viewing/editing permissions to certain sheet members only? If so, how?