This code might appear to not be functioning in the end but please note that I found a pair of curly brackets that were clipped off of the right side of the video at min 9:13 starting here: ua-cam.com/video/yahnz7yME9E/v-deo.html. I hope this helps someone. Great vid! Full code: function onEdit(e) {
let sheet = e.source.getActiveSheet(); let = thisRow = e.range.getRow(), thisColumn = e.range.getColumn(); let statusColumn = { top:3, //third row from the top bottom:12, //12th row from top col:3, //third col from the left }; if(thisRow >= statusColumn.top && thisRow = statusColumn.top && thisRow
Hi, thx for the video, but i have some issues when i copy a range of cells (edit cells), the script is not working, for example if you select the cell C3 with the value Hired then you copy that cell (C3) then paste in the range (C4:C8) thats when the script its not working, plss help
This code might appear to not be functioning in the end but please note that I found a pair of curly brackets that were clipped off of the right side of the video at min 9:13 starting here: ua-cam.com/video/yahnz7yME9E/v-deo.html. I hope this helps someone. Great vid!
Full code:
function onEdit(e) {
let sheet = e.source.getActiveSheet();
let = thisRow = e.range.getRow(),
thisColumn = e.range.getColumn();
let statusColumn = {
top:3, //third row from the top
bottom:12, //12th row from top
col:3, //third col from the left
};
if(thisRow >= statusColumn.top && thisRow = statusColumn.top && thisRow
you are awesome man, don't stop posting these videos
Worked like a champ! Thanks!
Hi, thx for the video, but i have some issues when i copy a range of cells (edit cells), the script is not working, for example if you select the cell C3 with the value Hired then you copy that cell (C3) then paste in the range (C4:C8) thats when the script its not working, plss help
I like the script, how we can add username or user email after last edit column?
Is timestamp for defined values(Number or word ) possible?
It worked for some time. Now, it's not working anymore. Even so, thank you very much for the video!
Some script share u
HOW ABOUT TIME STAMP IN NEW SHEET