I have a spreadsheet for a timetable where about 5 people work on. I want only the spreadsheet owner can view and edit certain (confidential) data. This confidential data is needed for formula's in other sheets in the spreadsheet.
What I do now is, using
IMPORTRANGE(), in a separate sheet and make this invisible for other users.
What I look for is a method to make one sheet of a spreadsheet (or columns) invisible for a certain group of users.