I just started exploring google sheets and javascript and I wrote a function which prompts the user to type a string which is entered into the selected cell. I’m accessing the current cell using SpreadsheetApp.getActiveSheet().getActiveCell() and setting the value using .setValue().
Now I made another prompt and I want to put this value in the cell next to the selected cell (same row but column+1). How do I access the current cells row and column positions and then increment the col with 1?
In pseudo code im thinking something like this;
ActiveCell[row][column+1] = string input from prompt2
>Solution :
Try using offset to specify offset:
let cell = SpreadsheetApp.getActiveSheet().getActiveCell();
// update cell to the right
cell.offset(0, 1).setValue("upd");