Is it possible to prohibit editing a cell with the result of the script?

Question

excel

In the Google table, next to the cell, the script displays the so-called. timestamp - the date the cell was last edited. I wish managers couldn't edit this column (with a timestamp). If I include it in a protected range, then the script cannot write anything there under the manager's account.
Can this be organized somehow?

Answer 1

well, as an option:
1. make a separate sheet (script) on which the script, for example, in A1 will write the timestamp value.
2. Equate the desired cell on sheet 1 with a formula to a new cell (=script!A1) and protect it from selection, etc.
3. We make the script sheet hidden or super hidden.

Answer 2

You have to look at the script itself. But, as an option, I would do this - I would start another column, invisible to managers, and duplicate the entry there in the script. Those. the script would write a record there, but a manual change will not be reflected in this column. Well... at least until the managers get wind of what the catch is. ))