I have a Google spreadsheet that ~30 members can edit (one row for each member). I need to create a column showing "yes" as default in each row until the member manually changes it to "no" if he/she considers applicable. Every Monday morning at 6 am, I need this column to automatically change back to default "yes". Anyone can help with the code?


Assuming the column is B for the purpose of this example, here's a function that fills it with "yes":

function yes() {
  var ss = SpreadsheetApp.openById( ... );  // see below
  var sheet = ss.getSheetByName("Sheet1");  // the name of the sheet
  var range = sheet.getRange("B1:B");       // or another column
  var numRows = range.getHeight();
  var values = [];   
  for (var i=0; i<numRows; i++) {

The id of a spreadsheet is in its URL: /spreadsheets/d/.../edit

To execute this function daily, go to Resources > Current projects' triggers, create a daily trigger and specify its running time.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.