Google App Script - List all sheets containing Announcing the arrival of Valued Associate #679: Cesar Manara Planned maintenance scheduled April 23, 2019 at 23:30 UTC (7:30pm US/Eastern) Data science time! April 2019 and salary with experience The Ask Question Wizard is Live!Using Google Script to get an array from a list of cells in google sheetGoogle Sheets Filter with IN clauseChanging A Cell Value in a Range Only When It Meets A Condition(Google Sheets App Scripts)Google Apps Sheets Script .getRange ProblemsGoogle Sheets Script to return sheet name will not automatically update on creating a new sheetCopying data from an array into a range in Google Sheets using scriptGoogle Sheet: Script - Copy/Paste, Time delay, Copy/Paste, repeat for all values in columnHow to parse a range in Google Sheets scriptGoogle Script to email PDF from specific google sheet sends all sheets on some sheets, not othersCustom sumif function for all sheets in workbook - Google Sheets Script
The test team as an enemy of development? And how can this be avoided?
What does 丫 mean? 丫是什么意思？
How can I set the aperture on my DSLR when it's attached to a telescope instead of a lens?
Lagrange four-squares theorem --- deterministic complexity
One-one communication
What do you call the main part of a joke?
How to compare two different files line by line in unix?
How often does castling occur in grandmaster games?
What order were files/directories output in dir?
What is the chair depicted in Cesare Maccari's 1889 painting "Cicerone denuncia Catilina"?
How many time has Arya actually used Needle?
How were pictures turned from film to a big picture in a picture frame before digital scanning?
How much damage would a cupful of neutron star matter do to the Earth?
Why is it faster to reheat something than it is to cook it?
What is the meaning of 'breadth' in breadth first search?
How do living politicians protect their readily obtainable signatures from misuse?
How could we fake a moon landing now?
What does it mean that physics no longer uses mechanical models to describe phenomena?
Significance of Cersei's obsession with elephants?
Putting class ranking in CV, but against dept guidelines
Why do early math courses focus on the cross sections of a cone and not on other 3D objects?
The Nth Gryphon Number
AppleTVs create a chatty alternate WiFi network
How to report t statistic from R
Google App Script - List all sheets containing
Announcing the arrival of Valued Associate #679: Cesar Manara
Planned maintenance scheduled April 23, 2019 at 23:30 UTC (7:30pm US/Eastern)
Data science time! April 2019 and salary with experience
The Ask Question Wizard is Live!Using Google Script to get an array from a list of cells in google sheetGoogle Sheets Filter with IN clauseChanging A Cell Value in a Range Only When It Meets A Condition(Google Sheets App Scripts)Google Apps Sheets Script .getRange ProblemsGoogle Sheets Script to return sheet name will not automatically update on creating a new sheetCopying data from an array into a range in Google Sheets using scriptGoogle Sheet: Script - Copy/Paste, Time delay, Copy/Paste, repeat for all values in columnHow to parse a range in Google Sheets scriptGoogle Script to email PDF from specific google sheet sends all sheets on some sheets, not othersCustom sumif function for all sheets in workbook - Google Sheets Script
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;
I am trying to list all sheets that contain certain value in a cell.
I used
function listsheets()
var out = new Array()
var sheets = SpreadsheetApp.getActiveSpreadsheet().getSheets();
for (var i=0 ; i<sheets.length ; i++) out.push( [ sheets[i].getName() ] )
return out
How can I introduce the condition to list only those sheets that present "hello" value in the B2 cell?
google-apps-script
asked Mar 22 at 11:02
davidmartindavidmartin
32
add a comment |
I am trying to list all sheets that contain certain value in a cell.
I used
function listsheets()
var out = new Array()
var sheets = SpreadsheetApp.getActiveSpreadsheet().getSheets();
for (var i=0 ; i<sheets.length ; i++) out.push( [ sheets[i].getName() ] )
return out
How can I introduce the condition to list only those sheets that present "hello" value in the B2 cell?
google-apps-script
asked Mar 22 at 11:02
davidmartindavidmartin
32
1
Do more research and tutorials. Learn about what theifstatement does. developers.google.com/apps-script/guides/sheets#reading_data
– tehhowch
Mar 22 at 11:24
add a comment |
I am trying to list all sheets that contain certain value in a cell.
I used
function listsheets()
var out = new Array()
var sheets = SpreadsheetApp.getActiveSpreadsheet().getSheets();
for (var i=0 ; i<sheets.length ; i++) out.push( [ sheets[i].getName() ] )
return out
How can I introduce the condition to list only those sheets that present "hello" value in the B2 cell?
google-apps-script
asked Mar 22 at 11:02
davidmartindavidmartin
32
I am trying to list all sheets that contain certain value in a cell.
I used
function listsheets()
var out = new Array()
var sheets = SpreadsheetApp.getActiveSpreadsheet().getSheets();
for (var i=0 ; i<sheets.length ; i++) out.push( [ sheets[i].getName() ] )
return out
How can I introduce the condition to list only those sheets that present "hello" value in the B2 cell?
google-apps-script
google-apps-script
asked Mar 22 at 11:02
davidmartindavidmartin
32
asked Mar 22 at 11:02
davidmartindavidmartin
32
asked Mar 22 at 11:02
davidmartindavidmartin
32
asked Mar 22 at 11:02
davidmartindavidmartin
32
asked Mar 22 at 11:02
davidmartindavidmartin
32
32
1
Do more research and tutorials. Learn about what theifstatement does. developers.google.com/apps-script/guides/sheets#reading_data
– tehhowch
Mar 22 at 11:24
add a comment |
1
Do more research and tutorials. Learn about what theifstatement does. developers.google.com/apps-script/guides/sheets#reading_data
– tehhowch
Mar 22 at 11:24
1
1
Do more research and tutorials. Learn about what the
if statement does. developers.google.com/apps-script/guides/sheets#reading_data– tehhowch
Mar 22 at 11:24
Do more research and tutorials. Learn about what the
if statement does. developers.google.com/apps-script/guides/sheets#reading_data– tehhowch
Mar 22 at 11:24
add a comment |
1 Answer
1
active
oldest
votes
If you use small sheets and certain cells you can use
function listsheets()
return SpreadsheetApp.getActive().getSheets().reduce(function(p, sheet)
if(sheet.getRange('B2').getValue() === 'hello')
p.push(sheet.getName());
return p;
, []);
answered Mar 22 at 11:36
oshliaeroshliaer
1,41111632
1
it works! thank you very much!
– davidmartin
Mar 22 at 11:47
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%2f55298223%2fgoogle-app-script-list-all-sheets-containing%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
If you use small sheets and certain cells you can use
function listsheets()
return SpreadsheetApp.getActive().getSheets().reduce(function(p, sheet)
if(sheet.getRange('B2').getValue() === 'hello')
p.push(sheet.getName());
return p;
, []);
answered Mar 22 at 11:36
oshliaeroshliaer
1,41111632
1
it works! thank you very much!
– davidmartin
Mar 22 at 11:47
add a comment |
If you use small sheets and certain cells you can use
function listsheets()
return SpreadsheetApp.getActive().getSheets().reduce(function(p, sheet)
if(sheet.getRange('B2').getValue() === 'hello')
p.push(sheet.getName());
return p;
, []);
answered Mar 22 at 11:36
oshliaeroshliaer
1,41111632
1
it works! thank you very much!
– davidmartin
Mar 22 at 11:47
add a comment |
If you use small sheets and certain cells you can use
function listsheets()
return SpreadsheetApp.getActive().getSheets().reduce(function(p, sheet)
if(sheet.getRange('B2').getValue() === 'hello')
p.push(sheet.getName());
return p;
, []);
answered Mar 22 at 11:36
oshliaeroshliaer
1,41111632
If you use small sheets and certain cells you can use
function listsheets()
return SpreadsheetApp.getActive().getSheets().reduce(function(p, sheet)
if(sheet.getRange('B2').getValue() === 'hello')
p.push(sheet.getName());
return p;
, []);
answered Mar 22 at 11:36
oshliaeroshliaer
1,41111632
answered Mar 22 at 11:36
oshliaeroshliaer
1,41111632
answered Mar 22 at 11:36
oshliaeroshliaer
1,41111632
answered Mar 22 at 11:36
oshliaeroshliaer
1,41111632
1,41111632
1
it works! thank you very much!
– davidmartin
Mar 22 at 11:47
add a comment |
1
it works! thank you very much!
– davidmartin
Mar 22 at 11:47
1
1
it works! thank you very much!
– davidmartin
Mar 22 at 11:47
it works! thank you very much!
– davidmartin
Mar 22 at 11:47
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%2f55298223%2fgoogle-app-script-list-all-sheets-containing%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
Do more research and tutorials. Learn about what the
ifstatement does. developers.google.com/apps-script/guides/sheets#reading_data– tehhowch
Mar 22 at 11:24