10
The way to address the problem is to use a combination of custom function in google spreadsheet and google script. I will use examples to try to address solution for your problem
Formula protection :
My understanding is you will have users enter new entries into a new row. This means you could apply the formula automatically to this new row, which might ...
Only top voted, non community-wiki answers of a minimum length are eligible
Related Tags
google-sheets × 6google-sheets-protection × 6
google-apps-script × 3
google-drive-sharing × 3
permissions × 2
google-sheets-cell-format × 1