I'm trying to set a default value for all the cells of a specific index whenever a new row in created in the spreadsheet.
I wanted to do this with the change event of the spreadsheet and basically do: get current selected cell position & go to my desired index on that row and add the default value. However i wasn't able to find how to get the selected's cell position in the change event function.
Another idea was to set a default value for my specific cell index with "sheets.rows.cells.value" but i see it needs a row index which in my case is dynamic.
Thanks a lot for the help