Google Apps Script set value to multiple cells
up vote
0
down vote
favorite
I have google spreadsheet and a function for it to calculate some values basing on first 3 cells in a row.
My problem is that this function returns multiple values which shold be placed in multiple cells in current row.
function test(arg1, arg2, arg3) {
return [arg1 + 1, arg2 + 1, arg3 + 1];
}
For example.
How i tell it to put values from array to different cells?
google-apps-script google-sheets edited Nov 22 at 19:13
Rubén
9,93043265
asked Nov 22 at 15:03
Vitali Skripka
427
add a comment |
up vote
0
down vote
favorite
I have google spreadsheet and a function for it to calculate some values basing on first 3 cells in a row.
My problem is that this function returns multiple values which shold be placed in multiple cells in current row.
function test(arg1, arg2, arg3) {
return [arg1 + 1, arg2 + 1, arg3 + 1];
}
For example.
How i tell it to put values from array to different cells?
google-apps-script google-sheets edited Nov 22 at 19:13
Rubén
9,93043265
asked Nov 22 at 15:03
Vitali Skripka
427
1
ReadsetValues()documentation
– TheMaster
Nov 22 at 15:28
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
I have google spreadsheet and a function for it to calculate some values basing on first 3 cells in a row.
My problem is that this function returns multiple values which shold be placed in multiple cells in current row.
function test(arg1, arg2, arg3) {
return [arg1 + 1, arg2 + 1, arg3 + 1];
}
For example.
How i tell it to put values from array to different cells?
google-apps-script google-sheets edited Nov 22 at 19:13
Rubén
9,93043265
asked Nov 22 at 15:03
Vitali Skripka
427
I have google spreadsheet and a function for it to calculate some values basing on first 3 cells in a row.
My problem is that this function returns multiple values which shold be placed in multiple cells in current row.
function test(arg1, arg2, arg3) {
return [arg1 + 1, arg2 + 1, arg3 + 1];
}
For example.
How i tell it to put values from array to different cells?
google-apps-script google-sheets google-apps-script google-sheets edited Nov 22 at 19:13
Rubén
9,93043265
asked Nov 22 at 15:03
Vitali Skripka
427
edited Nov 22 at 19:13
Rubén
9,93043265
asked Nov 22 at 15:03
Vitali Skripka
427
edited Nov 22 at 19:13
Rubén
9,93043265
edited Nov 22 at 19:13
Rubén
9,93043265
edited Nov 22 at 19:13
Rubén
9,93043265
9,93043265
asked Nov 22 at 15:03
Vitali Skripka
427
asked Nov 22 at 15:03
Vitali Skripka
427
asked Nov 22 at 15:03
Vitali Skripka
427
427
1
ReadsetValues()documentation
– TheMaster
Nov 22 at 15:28
add a comment |
1
ReadsetValues()documentation
– TheMaster
Nov 22 at 15:28
1
1
Read
setValues() documentation– TheMaster
Nov 22 at 15:28
Read
setValues() documentation– TheMaster
Nov 22 at 15:28
add a comment |
1 Answer
1
active
oldest
votes
up vote
2
down vote
accepted
Assuming that the question is about a custom function, the following function will return a 1 row x 3 columns array
function test(arg1, arg2, arg3) {
return [[arg1 + 1, arg2 + 1, arg3 + 1]];
}
answered Nov 22 at 19:16
Rubén
9,93043265
add a comment |
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
2
down vote
accepted
Assuming that the question is about a custom function, the following function will return a 1 row x 3 columns array
function test(arg1, arg2, arg3) {
return [[arg1 + 1, arg2 + 1, arg3 + 1]];
}
answered Nov 22 at 19:16
Rubén
9,93043265
add a comment |
up vote
2
down vote
accepted
Assuming that the question is about a custom function, the following function will return a 1 row x 3 columns array
function test(arg1, arg2, arg3) {
return [[arg1 + 1, arg2 + 1, arg3 + 1]];
}
answered Nov 22 at 19:16
Rubén
9,93043265
add a comment |
up vote
2
down vote
accepted
up vote
2
down vote
accepted
Assuming that the question is about a custom function, the following function will return a 1 row x 3 columns array
function test(arg1, arg2, arg3) {
return [[arg1 + 1, arg2 + 1, arg3 + 1]];
}
answered Nov 22 at 19:16
Rubén
9,93043265
Assuming that the question is about a custom function, the following function will return a 1 row x 3 columns array
function test(arg1, arg2, arg3) {
return [[arg1 + 1, arg2 + 1, arg3 + 1]];
}
answered Nov 22 at 19:16
Rubén
9,93043265
answered Nov 22 at 19:16
Rubén
9,93043265
answered Nov 22 at 19:16
Rubén
9,93043265
answered Nov 22 at 19:16
Rubén
9,93043265
9,93043265
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53433712%2fgoogle-apps-script-set-value-to-multiple-cells%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
1
Read
setValues()documentation– TheMaster
Nov 22 at 15:28