var countdownrange = e.source.getSheetByName('validated').getRange(row, 4);
countdownrange.setFormulaR1C1("=R[0]C[-1]-R[0]C[-2]");
var nowrange = e.source.getSheetByName('validated').getRange(row, 3);
nowrange.setFormula("=NOW()");