Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function onEdit(e) {
- const row = e.range.getRow();
- const col = e.range.getColumn();
- if ([1,2].includes(col) && row >= 6 && e.source.getActiveSheet().getName() == "Data") {
- const offsetValue = e.range.offset(0,(col == 2) ? -1 : 1 ).getValue()
- if (offsetValue === 0 && Number(e.value) === 0) {
- const currentDate = new Date();
- e.range.offset(0,(col == 2) ? 2 : 3 ).setValue(currentDate);
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement