Google Apps Script set value to multiple cells
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 '18 at 19:13
Rubén
10.6k43467
asked Nov 22 '18 at 15:03
Vitali SkripkaVitali Skripka
487
add a comment |
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 '18 at 19:13
Rubén
10.6k43467
asked Nov 22 '18 at 15:03
Vitali SkripkaVitali Skripka
487
1
ReadsetValues()documentation
– TheMaster
Nov 22 '18 at 15:28
add a comment |
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 '18 at 19:13
Rubén
10.6k43467
asked Nov 22 '18 at 15:03
Vitali SkripkaVitali Skripka
487
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 '18 at 19:13
Rubén
10.6k43467
asked Nov 22 '18 at 15:03
Vitali SkripkaVitali Skripka
487
edited Nov 22 '18 at 19:13
Rubén
10.6k43467
asked Nov 22 '18 at 15:03
Vitali SkripkaVitali Skripka
487
edited Nov 22 '18 at 19:13
Rubén
10.6k43467
edited Nov 22 '18 at 19:13
Rubén
10.6k43467
edited Nov 22 '18 at 19:13
Rubén
10.6k43467
10.6k43467
asked Nov 22 '18 at 15:03
Vitali SkripkaVitali Skripka
487
asked Nov 22 '18 at 15:03
Vitali SkripkaVitali Skripka
487
asked Nov 22 '18 at 15:03
Vitali SkripkaVitali Skripka
487
487
1
ReadsetValues()documentation
– TheMaster
Nov 22 '18 at 15:28
add a comment |
1
ReadsetValues()documentation
– TheMaster
Nov 22 '18 at 15:28
1
1
Read
setValues() documentation– TheMaster
Nov 22 '18 at 15:28
Read
setValues() documentation– TheMaster
Nov 22 '18 at 15:28
add a comment |
1 Answer
1
active
oldest
votes
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 '18 at 19:16
RubénRubén
10.6k43467
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
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
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
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 '18 at 19:16
RubénRubén
10.6k43467
add a comment |
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 '18 at 19:16
RubénRubén
10.6k43467
add a comment |
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 '18 at 19:16
RubénRubén
10.6k43467
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 '18 at 19:16
RubénRubén
10.6k43467
answered Nov 22 '18 at 19:16
RubénRubén
10.6k43467
answered Nov 22 '18 at 19:16
RubénRubén
10.6k43467
answered Nov 22 '18 at 19:16
RubénRubén
10.6k43467
10.6k43467
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.
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 '18 at 15:28