The least I can say is BRILIANT! The only issue I have is that the method does not seem to like dropdown menus. It will update after I select on the dropdown menu after I have made my choice. Not a big issue. Thank you!
This is great solution for a simple timesheet. However, I would echo the comments from Basil K a few months ago. I tried having a pulldown menu or a check box in the trigger cell. Everything looked great they day I was using the sheet, but when I open the sheet on alter day, all the stamps triggered on the same day default to having the same timestamp. This was true of the pulldown or check box triggers. Sad to say, I don't know enough to figure out what is happening...
HI Doug, I did all the steps. It works great on the day. But the time changes the next day. Is there a formula where the static time become permanent. FYI I'm using the NOW() function for staff attendance.
I have to tell you that I have been working this with script approachment for a static timestamp for the last 2 days but it's quite difficult if you didn't follow the script lesson from the start, and then I try your way, this works like magic. THANK YOU! You are a lifesaver :")
hi, i entered =IF(K2271"",if(Q2271="",NOW(),Q2271),"") but noticed that my googlesheet updates when data in entered in the next cell. the data updates across all
Hi Doug, Love this, its so much better than the scripting approach. I would like this function to be triggered by a checkbox. I have changed the B2 to B2="FALSE", so the formular reads =IF(B2="FALSE",if(C2="",today(),C2),"") but it doesn't work.
its so simple i can't believe it. I have been racking my brain on this for hours. thank you so much!!
Thanks lance harmon, glad it helped!
The least I can say is BRILIANT!
The only issue I have is that the method does not seem to like dropdown menus. It will update after I select on the dropdown menu after I have made my choice.
Not a big issue.
Thank you!
Hi Basil Kezios, you're welcome!
I very much like the way you solved this problem. Works great.Thank you!
Glad you thought so, thanks!
Amazing I have been looking for this for over an hour, finally you saved me. Thank you
Glad I could help
This is great solution for a simple timesheet. However, I would echo the comments from Basil K a few months ago. I tried having a pulldown menu or a check box in the trigger cell. Everything looked great they day I was using the sheet, but when I open the sheet on alter day, all the stamps triggered on the same day default to having the same timestamp. This was true of the pulldown or check box triggers. Sad to say, I don't know enough to figure out what is happening...
Thanks!!! That was very helpful!
Glad it helped!
Hi doug, how about if you what to apply it to more than one cell, also how do you avoid tempering assuming the sheet is accessible to many people
Thank you!! It worked for me.
You’re welcome!
This was exactly what I was looking for! Thank you :)
You're very welcome!
HI Doug, I did all the steps. It works great on the day. But the time changes the next day. Is there a formula where the static time become permanent. FYI I'm using the NOW() function for staff attendance.
for me the same. did every step but if I reload the sheet the day after, the date is updated as well... toughts?
@@panick88it Me too!
Date is changing on every day, it is due to some updates done by Google...need to wait
Thank you so much! It help me a lot!
You're welcome!
Sir, thanks a lot for this tutorial. was wanting exactly this type of data input for some personal data analysis of mine. with regards
Glad it helped you and thanks for commenting!
AWESOME, AWESOME, AWESOME! Thanks so much.
You're very welcome!
It was helpful. Thank you for sharing this tricks.
My pleasure 😊
I have to tell you that I have been working this with script approachment for a static timestamp for the last 2 days but it's quite difficult if you didn't follow the script lesson from the start, and then I try your way, this works like magic. THANK YOU! You are a lifesaver :")
Glad to hear it helped!
Thanks Doug. However, Time stamp changes the next day when i reload. Anything missing?
OK TERY TO CARRY THE CELL FROM B1 TO B5 AND SEE HOW THE TIME WILL AUTO RESET
Thanks a lot man.. !!!!!!!
You’re welcome!
thank you
You’re welcome!
will this give correct date (and time) if data is programmatically changed in cell C2? (eg via an import done through apps script)
hi, i entered =IF(K2271"",if(Q2271="",NOW(),Q2271),"") but noticed that my googlesheet updates when data in entered in the next cell. the data updates across all
I have a problem...when there is the value in the another cell before the formula, the formula don't works
thanks a lot
You’re welcome!
Hi Doug, this is exactly what I am after but my Date is reading 30/12/1899 00:00:00 any idea why this would be happening?
=IF(C4"",if(D4="",now(),D4),"") is the code im using
Could be the display format. This may help. Change Dates to Make it Easier to Read
ruclips.net/video/Aezn5JiWECE/видео.html
Good trick
Hi Let's Learn, thanks for the comment!
what if it's a checkbox instead of typing something to trigger the formula?
i want it to be static even after you uncheck the checkbox. pls help
ur the one
Thanks!
what if you change the cell position
is it possible to make it fix when changing the row position
Thank you sir that was very helpful 🙏
Edit: I noticed that the values get to 0 after I reopen the sheet :(
Hi Ezpzdz, thanks for the comment!
Super Man, U rokssss
Thank you so much 😀
Can you get a timestamp the last time a cell was updated?
There's not a function that I know of, but there's scripts that could be used for it...I'm not familiar with the scripting.
That's a lot simpler than writing javascript in App Script and doesn't the user to Allow Scripting
Hi Northern Exposure, thanks for the comment!
Hi Doug, Love this, its so much better than the scripting approach. I would like this function to be triggered by a checkbox. I have changed the B2 to B2="FALSE", so the formular reads =IF(B2="FALSE",if(C2="",today(),C2),"") but it doesn't work.
Don't use "FALSE", use FALSE without double commas.
Hi philip,,i have the same idea with you to use a check box,,im using this formula =IF(B2FALSE,IF(C2="",NOW(),C2),"")
@@warblender5657 solid & reliable approach. simple enough to be deployed by any one.
Its like Google finds out we are trying to do logical arguments and they stop letting it work.
I did exactly what you did and can not get it to work
Just used your strategy. Tomorrow I'll see if it works for me. If it works, I'll subscribe and like the video. Thank you so much
Great, thanks!