How to create an edit access control in Google Sheets?

Question

Software and Internet Services

Need help with this issue. There is a file in Google Sheets with formulas that, in accordance with the values ​​entered in certain cells, calculate the salary of an employee. There are 1000 employees of the company. How to make it so that each individual employee can enter his data into the table, which is not visible to others, and calculate wages for himself. The payroll scheme changes every day, so offline resources will be inefficient.

Perhaps there is some free analogue of Google Spreadsheets with access control? Or extensions, add-ons? I really need an alternative.

Answer 1

You need to set up a normal web portal, with authorization for each person. And only then from there this data should be reduced
. Tables do not imply such functionality