I am currently trying to find a way to set a protected 'default' cell value on Google sheets so that I can have a formula 'locked' in the cell. I need this to work in such a way that if someone was to edit the cell and then delete what they had entered it would revert back to the protected 'default' value. This is because I need a cell to do multiple jobs acting upon other cells with said formula or sometimes being a cell data is input into to effect other cells. My other idea was to get a formula to output to a different cell than the one that it is entered into, but I don't know if this is possible either. EG. =IF(A1=1,B1=2,B1=1) (this formula is typed in C1)
If this is the wrong place to post this question then please let me know, but I am running out of ideas as to how to get this to work now!
Thanks in advance.