I'm trying to figure out how to accomplish the following:

1. Protect the sheet
2. Iterate through each row

• If Column 1 contains a date that is > 7 days before the current date then
• • unprotect column 3, 4, 5, 6 (within that row)
• • Otherwise do nothing

I've reworked some other examples I found online, but I've been far from successful.

CodePudding user response：

Protects sheet unprotects rows > 7 days before the current date

function serveButNotProtect() {
  const ss = SpreadsheetApp.getActive();
  const sh = ss.getSheetByName("Sheet0");
  const osh = ss.getSheetByName("Sheet1");
  const vs = sh.getRange(2, 1, sh.getLastRow() - 1, sh.getLastColumn()).getValues();
  let p = sh.protect();
  const a = [];
  const dt = new Date();
  const dtv = new Date(dt.getFullYear(), dt.getMonth(), dt.getDate() - 7).valueOf();
  vs.forEach((r, i) => {
    let dv = new Date(r[0]);
    if (dv > dtv) {
      a.push(sh.getRange(i   2, 3, 1, 4))
    }
  });
  if (a && a.length > 0) {
    p.setUnprotectedRanges(a);
  }
  let b = p.getUnprotectedRanges().map(rg => [rg.getA1Notation()]).sort((a, b) => {
    let va = parseInt(a[0].slice(1, a[0].indexOf(':')));
    let vb = parseInt(b[0].slice(1, b[0].indexOf(':')));
    return va - vb;
  });
  osh.clearContents();
  osh.getRange(1, 1, b.length, b[0].length).setValues(b);
}

Sheet0:

Sheet1:

Unproted Ranges: