Question
Update different column's row in google sheet
HI ,
I am using "Google Sheet Connected System" to write data in google sheet .
I am trying to write data in the different columns for example column is I & J so range and values are-
Ranges:-
" Sheetname&"!I2:J" "
values:-
{
"Text10@Text4",
"Text2@Text5",
"Text3@Text6"
}
but If i want to update the column T also and giving range :-
Sheetname&"!I2:T"
values : _
{
"Text10@Text4@Text9",
"Text2@Text5@Text8",
"Text3@Text6@Text7"
}
In this case ,T column is not updating or writing anything.
So Can anyone tell me that what will be the correct way to update or write in the google sheet.
Thanks in advance