Mr. Berry, you are an incredible teacher. How you explain everything with such details takes many years to learn, not to mention how much longer it takes to put this video together in a form that can be understood and learned by us all. Another job WELL done. Thank you
That's a very informative and helpful video Mr B, it must have taken a lot of your time and care to put this together. Thank you so much for all you do.
Here is my script (it's to add an automatic time stamp in an adjacent column), for some reason even though I added 3 tab names, it still applies to all of my 5 tabs. However I searched up about the 'exclude' and 'only' function, but I'm not sure how to apply it to my function, can someone please help? I'm a bit new here... (Also if anyone can help make it so the timestamp doesn't change once it's been made, I'd really appreciate it...) function onEdit() { var s = SpreadsheetApp.getActiveSheet(); if( s.getName() == 'Магнит1','Орбита','Котельщик') { var r = s.getActiveCell(); if( r.getColumn() == 3 ) { var nextCell = r.offset(0, -1); if( nextCell.getValue() === '' ) nextCell.setValue(new Date()); } } }
I see that yo posted the question here too: stackoverflow.com/questions/64555243/how-to-fix-my-google-spreadsheets-script-i-need-it-to-only-apply-to-3-of-my-5-t
@@дмитрийлазуренко-х3ы No problem at all. In fact, thank you for the question. Sorry that I do not have an correct answer to give you. I was working with excel scripts a number of years back, but now i am busy teaching my classes and creating my lessons, videos, and content for my classes
![Kodak Black - Catch Fire [Official Music Video]](http://i.ytimg.com/vi/A4ch-olIuZo/mqdefault.jpg)
thanks so much helped a lot!
You're welcome. I am happy it helped.
Mr. Berry, you are an incredible teacher. How you explain everything with such details takes many years to learn, not to mention how much longer it takes to put this video together in a form that can be understood and learned by us all. Another job WELL done. Thank you
I am always happy to help.
We need more teachers like you
Thank you for the wonderful comment. Please subscribe and enjoy my other videos on using technology.
That's a very informative and helpful video Mr B, it must have taken a lot of your time and care to put this together. Thank you so much for all you do.
Glad it was helpful!
Mr Berry i finished the projects. PS its Jean by the way
Yes. Thank you.
Here is my script (it's to add an automatic time stamp in an adjacent column), for some reason even though I added 3 tab names, it still applies to all of my 5 tabs. However I searched up about the 'exclude' and 'only' function, but I'm not sure how to apply it to my function, can someone please help? I'm a bit new here... (Also if anyone can help make it so the timestamp doesn't change once it's been made, I'd really appreciate it...)
function onEdit() {
var s = SpreadsheetApp.getActiveSheet();
if( s.getName() == 'Магнит1','Орбита','Котельщик') {
var r = s.getActiveCell();
if( r.getColumn() == 3 ) {
var nextCell = r.offset(0, -1);
if( nextCell.getValue() === '' )
nextCell.setValue(new Date());
}
}
}
I see that yo posted the question here too: stackoverflow.com/questions/64555243/how-to-fix-my-google-spreadsheets-script-i-need-it-to-only-apply-to-3-of-my-5-t
@@selmateacher7 Yeah... I did. It's just urgent for me and I wanted to get someone to answer.
I'm sorry if this is an issue.
@@дмитрийлазуренко-х3ы No problem at all. In fact, thank you for the question. Sorry that I do not have an correct answer to give you. I was working with excel scripts a number of years back, but now i am busy teaching my classes and creating my lessons, videos, and content for my classes