var ss = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(‘DUE’);
ss.getRange(“G2”).setFormula(“=if(D:D=false, “NOT PAID”, “PAID”)”);
var lr=ss.getLastRow();
var fillDownRange = ss.getRange(2, 7, lr-1);
ss.getRange(“G2”).copyTo(fillDownRange);
THIS IS MY SCRIPT BUT IT SHOWING ERROR, ANY OTHER FORMULA FOR THIS CONDITION