@Dzmitry to achieve this I was thinking to create a function for paste which will update the formula reference. Is there any way where I can create function like this, Maybe you can give me a start to create a function like this as I have logic in …
I am not sure what is wrong here, I am using same code as yours now, still it's not displaying me spreadsheet. no errors in console.
As soon as I remove just button code,rows: [
view: "button", value: "Update", width: 200