Relative Content

Tag Archive for google-sheetsgoogle-apps-scriptgoogle-sheets-formula

Lock google sheets for data entry after a wrong entry

I have a google sheet where many collaborators are there doing data entry. I want that if there is a wrong entry then the sheet will be automatically locked. I write below code in google app script but it not happen.

Google Sheets: Update Cell when changes to spreadsheet

I’m trying to re run a formula that sums all of the cells with a certain color. When I call the function, it runs correctly. After I add a another cell with the same colour it should re run and increase the number by 1. If I delete the cell and then type in the function again it works. Here is the code for the function