Google sheet custom function return editing problem

Question

I am trying to make a custom function in google sheet that take two argument and fill the cell from where it was called and its adjacent cell also will be fill. Adjacent cell also need to accept other value. I use

function replaceAdjacent(a,b) {
    let c=[a,b];
    return [c];
}
                                           

This function fill both cell by provide argument but when i try edit the adjacent cell than it show #REFerror.

How can I avoid this error with adjacent cell make editable?

Answer 1

A cell value must be set manually or calculated by a formula, it cannot be both, that is why you get the overwrite data error.

You can call your function using a button and update the cell values using setValues(), this way you can set data manually or by calling your function.