« first day (2695 days earlier)      last day (2256 days later) » 

Jacob Jan Tuinstra
Jacob Jan Tuinstra
8:22 AM
Hi Rubén, this is how I would write the script:
function myFunction() {
var forBidden = ["Setting", "Help", "FAQ"];
SpreadsheetApp.getActiveSpreadsheet().getSheets().forEach( function (d) {
if(forBidden.indexOf(d.getName()) === -1) {
d.getRange("A1").setValue("test");
}
});
}
And this is what I meant by pre-setting the name:
function myFunction() {
var ss = SpreadsheetApp.getActive();
var allsheets = ss.getSheets();
for(var s in allsheets){
var sheet = allsheets[s], name = sheet.getName();

// Stop iteration execution if the condition is meet.
if(
(name == "Setting") ||
(name == "Help") ||
(name == "FAQ")
) continue;

//your code here

} // end of loop

} // end of function
 
 
10 hours later…
Rubén
Rubén
6:42 PM
@JacobJanTuinstra Before reading this I added something similar to my answer.
@JacobJanTuinstra What I meat was that you post your approach as an answer so the OP could easily see it. More answers is better :)
 

« first day (2695 days earlier)      last day (2256 days later) »