Hello,
Appreciate any help…
Within Google sheets I need 3 different date/time stamps based on triggers within the sheets. I have a script that seems to work for the first 2 but not the last. Have looked in a number of forums but cannot find the answer. The screen shot below describes the problem and script is also included. Thank you!
---------------script---------------------
function onEdit(e) {
Loans(e);
In(e);
Entered(e);
}
function Loans(e) {
var s = e.source.getActiveSheet(),
watchCols = [1],
offsetCol = [10],
ind = watchCols.indexOf(e.range.columnStart)
if (col === 1 && s.getRange(row, 11).getValue() === “”) {
e.range.offset(0, offsetCol[ind])
.setValue(e.value ? new Date() : null);}
function In(e) {
var s = e.source.getActiveSheet(),
watchCols = [9],
offsetCol = [1],
ind = watchCols.indexOf(e.range.columnStart)
if (s.getName() !== “In” || ind === 1) return;
e.range.offset(0, offsetCol[ind])
.setValue(e.value ? new Date() : null);}
function Entered(e) {
var s = e.source.getActiveSheet(),
watchCols = [1],
offsetCol = [21],
ind = watchCols.indexOf(e.range.columnStart)
if (col === 1 && s.getRange(row, 22).getValue() === “”) {
e.range.offset(0, offsetCol[ind])
.setValue(e.value ? new Date() : null);}
}
}