Screenshot (39).png
Can someone help me? I'm using google sheet and I was wondering if there was a way to permanently save the time and date registered once I've ticked the boxes.
I noticed that everytime I close the browser and go to google sheets, the time always updates. Thank you
This is the link to the Google Sheet: https://docs.google.com/spreadsheets...it?usp=sharing
Last edited by alfie4030; 01-29-2024 at 02:49 AM.
Formulas should NEVER be relied upon for static (unchanging) timestamps.
The only way to create a timestamp when a checkbox is checked is with an apps script.
See this apps script added to your file:
Note that you should modify the GMT offset according to your needs.
Please Login or Register to view this content.
Last edited by janmorris; 01-29-2024 at 04:12 AM.
As a gesture off appreciation, you can click * Add Reputation at the foot of any of the posts of members who helped you reach a solution.
And finally, was your problem solved? if so, please click Thread Tools above the first post of your enquiry, then select [Solved]
Thank you soo much sir. Much appreciated. If I use MS Excel will I do the same thing? or is it another story.Originally Posted by janmorris
Formulas should NEVER be relied upon for static (unchanging) timestamps.
The only way to create a timestamp when a checkbox is checked is with an apps script.
See this apps script added to your file:
Note that you should modify the GMT offset according to your needs.Please Login or Register to view this content.
For Excel, VBA is the scripting language.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks