How to Lock a Formula in Google Sheets! - TechJunkie
FBTwitterReddit
video description
Rating: 4.0; Vote: 1
How to Lock a Formula in Google Sheets! - TechJunkie
Google Sheets makes it super easy to share documents with anyone, so collaborating with coworkers on spreadsheets is a snap. The ease that comes with it, however, also makes it easy for a user to change critical formulas the spreadsheet relies on, whether intentionally or unintentionally. On the bright side, Google Sheets gives you a lot of control over permissions for users
Princess: On Excel, there is an ability to make the data (formula) inside a cell hidden. - Select a cell, right click, format cell. On that dialog box, choose protection tab and tick hidden, then protect the sheet.- Whatever data (formula) you put inside that cell will be hidden and un-editable.- Does Gsheet have the same function? Date: 2022-03-28
