Timestamp with Checkboxes in Google Sheets
ฝัง
- เผยแพร่เมื่อ 19 ม.ค. 2025
- In this #youtube content you will learn how to generate a timestamp that is based on a checkbox in #googlesheets You will use an IFS function and a Now function along with iterative calculations to make the function work. Have fun!
Please #subscribe and Like the Video to support the channel Here and receive more FREE Content: / @leanstrategiesinterna...
Want to sign up for more advanced features on google #workspace and help the channel out? Visit: www.leanstrate...
You can learn more about Google Sheets Here: • Google Workspace
The Formula shown in this video is:
=IFS(C2=FALSE,"",D2="",NOW(),TRUE,D2)
You will then need to go to file, then settings and select calculations and then turn on iterative calculations.
For a review of this function and the function watch this video: • Review of Timestamp wi...
** Note: you will need to select the appropriate cells where "C2 and D2" are.
Others said it can only be done with app scripts, but you’re amazing-you actually achieved it directly with a formula. So impressive!
HUGE help! I searched other ways and none of the functions worked until I found your video! Thank you for your videos.
Glad it helped @kronen_bob If you are interested in more Google Workspace Content Please Visit This Great TH-cam Playlist: th-cam.com/play/PLX_1L8RY_Uz_hZNe3UX41-1zlUUasB9JW.html
This works a treat! After writing a script that didn't work perfectly, this was all I needed. Hilarious.
Thanks a million!
We are happy to help. If you're interested in more Google Workspace Tips Please Visit the Link Here: th-cam.com/play/PLX_1L8RY_Uz_hZNe3UX41-1zlUUasB9JW.html
Thank you for making this video! I've wanted a function like this for a while
No problem! Glad We could help. Thanks for being a part of the community. Also, If you are interested in more Google Workspace Content Please Visit This Great TH-cam Playlist: th-cam.com/play/PLX_1L8RY_Uz_hZNe3UX41-1zlUUasB9JW.html
Finally found an easy solution to this timestamp task. Thank you! Also, looks like the Fonz got into spreadsheets after Happy Days?
⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⣀⣤⣤⣶⣶⣶⣶⣾⣿⣿⣿⣿⣿⣶⣶⣄⡀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀
⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⣀⡴⠾⠿⠿⣿⣿⣿⣿⣿⣿⣿⣿⣿⠿⢋⠙⢿⠿⠿⠟⠓⠒⠤⢄⡀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀
⠀⠀⠀⠀⠀⠀⠀⠀⢀⡴⠞⠁⣐⣒⣚⣿⣿⣿⣿⣿⣿⣿⠿⣿⠋⣠⣾⡃⢀⠳⠄⠤⠾⣦⣄⠀⠘⠦⣀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀
⠀⠀⠀⠀⠀⠀⠀⣰⠏⣠⠞⠛⠉⠉⠉⠉⢩⣽⣿⠿⠿⡇⢀⣠⢸⣿⠿⡉⠉⣀⢴⣤⣴⣦⣽⣿⡇⢀⠈⠓⣄⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀
⠀⠀⠀⠀⠀⠀⢸⣿⡞⠁⠀⢠⣴⠄⠀⣿⣶⣤⣤⣴⣶⣾⣿⣯⣾⣿⣷⣦⣼⣿⣿⣿⣿⣿⣿⣿⣿⣏⠀⠀⠀⢃⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀
⠀⠀⠀⠀⠀⠀⢸⣿⣼⣦⡔⠋⣡⣴⡦⠀⠉⠛⠛⠛⠉⣉⣽⣿⣿⣿⣿⣿⣿⣿⣿⣿⣿⣿⣿⣿⣿⣷⣷⠿⢋⡀⣇⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀
⠀⠀⠀⠀⠀⠀⢸⣿⣿⣿⣷⣾⣥⣤⣤⣶⣿⣿⣶⣶⣶⣴⣿⣿⣿⣿⣿⣿⣿⣿⣿⣿⣿⣿⣿⣿⣿⣿⣿⣷⣾⣷⣜⠛⣄⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀
⠀⠀⠀⠀⠀⠀⠀⣿⢿⣿⣿⣿⣿⣿⣿⣿⣿⣿⣿⣿⣿⣿⣿⣿⣿⣿⣿⣿⣿⣿⣿⡿⠿⠿⠿⢿⣿⣿⣿⣿⣿⣿⣿⣄⠘⣆⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀
⠀⠀⠀⠀⠀⠀⠀⢸⡟⢿⣿⣿⣿⣿⣿⡿⠋⠉⠛⠻⠿⢿⣿⣿⣿⠿⠿⠛⠋⠉⠀⠀⠀⠀⠀⠀⠸⣿⣿⣿⣿⣿⣿⣿⣧⢈⣆⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀
⠀⠀⠀⠀⠀⠀⠀⣸⡷⠂⡍⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠺⣿⣿⣿⣿⣿⣿⣿⣿⢸⡄⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀
⠀⠀⠀⠀⠀⠀⣰⠟⠂⠀⡇⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠙⣿⣿⣿⣿⣿⣿⣿⣿⡀⢇⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀
⠀⠀⠀⠀⠀⠀⡇⢀⣲⣾⡇⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⣿⣿⣿⣿⣿⣿⣿⣿⣷⢸⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀
⠀⠀⠀⠀⠀⠀⡇⠀⢭⣹⣷⡄⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⢀⠀⣀⣠⣤⣴⣦⣤⡀⠀⠀⠀⠀⠈⢿⣿⣿⣿⣿⣿⣿⡿⢸⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀
⠀⠀⠀⠀⠀⠀⡇⢰⣽⣿⣿⣧⠀⠀⠀⠀⢀⣀⠀⠀⠀⠀⠀⠀⠀⠸⠼⠿⠿⠿⣿⡿⠿⠿⠛⠳⠄⠀⠀⠈⢿⣿⣿⣿⣿⣿⣟⣸⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀
⠀⠀⠀⠀⠀⠀⠸⣿⣿⣿⣿⣿⠀⠀⣰⣿⡿⡿⠷⠆⠀⠀⠤⠄⠀⢀⣠⣴⣾⣿⡿⣿⡿⣿⣷⣦⠀⠀⠀⠀⠘⣿⣿⣿⣿⡿⠟⢰⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀
⠀⠀⠀⠀⠀⠀⠀⠹⣿⣿⣿⣿⡇⠾⣿⣟⣰⡾⢿⣿⣿⣦⠀⠀⠀⠛⠻⠹⠛⠈⠛⠛⠁⠌⠋⠛⠂⠀⠀⠀⠀⢿⣿⣿⣿⣷⠚⢸⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀
⠀⠀⠀⠀⠀⠀⠀⠀⠙⣿⣿⣿⣧⠀⠼⣿⠏⠛⠟⠁⠈⠁⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⣼⣿⣿⣿⣿⡧⢸⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀
⠀⠀⠀⠀⠀⠀⠀⠀⠀⠈⠻⣿⣿⠀⠀⠈⠒⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⣿⣿⡿⣹⠟⠁⡞⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀
⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⢻⣿⡇⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠹⠿⠧⠅⠀⢠⠃⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀
⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠈⢹⠃⡀⠀⠀⠀⠀⠀⠀⢠⠀⠀⠀⠀⠀⠀⢀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⣆⠀⡠⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀
⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠁⠸⣷⡀⠀⠀⠀⠀⠀⠸⠀⠀⠀⠀⢀⣀⣀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠹⣿⡆⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀
⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠸⠷⡄⠀⠀⠀⠀⠀⠈⠒⠾⣾⠏⠉⠁⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⢠⠀⡏⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀
⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⢻⣆⠀⠀⠀⠀⠀⠀⠀⢠⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⣾⠀⡇⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀
⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠈⣿⡆⠀⠀⠀⠀⠀⢀⣈⣀⣠⣤⣤⣤⣤⠼⠛⠷⠄⠀⠀⠀⠀⠀⣸⡿⠀⢀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀
⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠸⣷⠀⣠⠾⠶⠾⠛⠛⠛⠋⠉⠀⠉⠁⠀⠀⠀⠀⠀⠀⠀⠀⣼⣿⠇⠀⢸⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀
⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠘⢷⣄⡀⠀⠀⢀⠐⣺⡖⢛⣥⣴⡂⠀⠀⠀⠀⠀⠀⢠⣾⣿⠏⠀⠀⠀⢨⣓⠤⣀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀
⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠈⣿⣷⠀⠀⠀⠽⠟⠛⠛⠉⠉⠀⠀⠀⠀⠀⠀⣴⣿⣿⠋⠀⠀⠀⠀⠸⣿⣿⣶⣝⡢⣀⠀⠀⠀⠀⠀⠀⠀⠀
⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⢀⠅⠙⢧⡀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⣠⣾⣿⡿⠁⠀⠀⠀⠀⠀⠀⠈⢻⣿⣿⣿⣦⡑⢄⣀⡀⠀⠀⠀⠀
⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⡠⠊⡆⠀⠈⠳⢦⣄⣀⡀⠀⠀⠀⠀⣀⣴⣾⣿⣿⡿⠁⠀⠀⠀⠀⠀⠀⠀⠀⠀⢹⣿⣿⣿⣿⣦⡀⠀⠉⠒⠤⡄
⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⣠⠊⠀⣸⣧⠀⠀⠀⠀⠈⠉⠛⠳⢶⣶⣿⣿⣿⣿⣿⡿⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠘⣿⣿⠙⣿⣿⣿⣶⠦⠄⠀⠀
⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⢀⠜⠁⠀⠤⣿⣿⠀⠀⠀⠀⠀⠘⠦⣄⣀⠈⠻⣿⣿⣿⡿⠁⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⣿⣿⠀⠈⢿⣿⣿⣷⣶⣶⡆
⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⢀⠠⠚⢁⡀⠀⢠⣼⣿⣿⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⢻⣿⡟⠁⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⣿⡏⠀⠀⢸⣿⣿⣿⣿⣿⡇
⠀⠀⠀⠀⠀⠀⠀⠀⠀⢀⠔⠁⠀⢠⡞⠀⠀⣸⣿⣿⣿⡆⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠉⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⢠⡟⠀⠀⠀⠈⣿⣿⡿⠿⢿⡇
⠀⠀⠀⠀⠀⠀⠀⢀⣠⢎⢌⡄⢠⡾⠋⠀⠀⣿⣿⣿⣏⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⢀⡴⠋⠀⠀⠀⠀⠀⣿⣿⣿⡷⢼⡇
⠀⠀⠀⢀⠠⠐⣨⢡⠄⣎⡾⢀⣼⡇⠀⠀⠀⣿⣿⣿⠻⣆⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⢀⣠⠴⠋⠀⠀⠀⠀⠀⠀⢰⣿⣿⣧⡘⣻⡇
⠤⠒⠊⠁⣀⣴⣷⡏⡜⣼⣿⣿⣿⠃⠀⠀⠀⢸⣿⣿⠀⠈⠣⣄⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⣀⣤⠴⠞⠋⠁⠀⠀⠀⠀⠀⠀⠀⠀⢸⣿⣿⣿⣷⣽⡇
⠀⣀⣴⣾⡿⣿⡟⣰⠙⡿⢸⣿⠃⠀⠀⠀⢀⣸⣿⣿⠀⠀⠀⠈⠙⠲⠦⠤⣤⣤⣄⣀⣀⣤⡤⠴⠶⠚⠋⠉⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⢸⣿⣿⣿⣿⣿⡇
⢈⣉⣤⣤⣶⡿⢱⠃⣾⡇⢿⠃⠀⠀⠠⠚⢁⣿⣿⣿⡄⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⢸⣿⣿⣿⣿⣿⡇
Wooow🎉great,brilliant solution! Without difficult scripts and soooo simple❤ thank you sooo much 😊
You are very welcome @user-cd6yn5ny7j we appreciate the your #comment in the #community. If you would like more helpful videos on #Googlesheets please feel free to visit: th-cam.com/play/PLX_1L8RY_Uz_7aPeXFi52OCFdSK03wUbT.html
Perfect! So helpful! Thank you!
Thank you sir. You've just saved my day!!
Glad this helped! Please feel free to check out more of our #googleworkspace videos here: th-cam.com/play/PLX_1L8RY_Uz_hZNe3UX41-1zlUUasB9JW.html
Perfect video, thanks so much!
Thank you @karolpaz4090 we appreciate the #positive comments in the #community. If you would like more helpful videos on Google Sheets, please feel free to visit: th-cam.com/play/PLX_1L8RY_Uz_7aPeXFi52OCFdSK03wUbT.html
I have follow this to use "=DAY(TODAY())" with time zone CST and iterations on in settings but all dates get updated ever day automatically, is there any way so that the past date stay same and dont get updated? any quick response would be appreciated .
Thank you for asking @user-uf3ol7kc4v. It looks like your formula would update everyday. Try watching the video (th-cam.com/video/AsGyokG6ITY/w-d-xo.htmlsi=5snaA7c5SmbK3vKl) and adjusting your formula based on the video. Please note the cell references that you use may be different from the video.
big thanks
You are very welcome @shotgunheist6536 we appreciate the #graditude of your comment in the #community. If you would like more helpful videos on #Googlesheets please feel free to visit: th-cam.com/play/PLX_1L8RY_Uz_7aPeXFi52OCFdSK03wUbT.html
Thank you!!
You're Welcome! Please feel free to check out more of our #googleworkspace videos here: th-cam.com/play/PLX_1L8RY_Uz_hZNe3UX41-1zlUUasB9JW.html
you saved my life oh my God
Big help man!
Awesome! Happy to help @migueljaballas81 we appreciate the your #comment in the #community. If you would like more helpful videos on #Googlesheets please feel free to visit: th-cam.com/play/PLX_1L8RY_Uz_7aPeXFi52OCFdSK03wUbT.html
When i type , after false the word false change to black insted of stay in blue.
Thanks for sharing this. You might want to re-check your formula.
My date keeps showing 30th December 1899?
Hi @WarmApplePye, thank you for asking this. The default date in #googlesheets is December 30, 1899. With that in mind your date will default to this time. Try checking your box, unchecking it and then checking it again. If your sheet is setup and formatted the same way as the one in the video this will correct the date. Thank again for being a part of the community. If you would like more helpful videos on #Googlesheets please feel free to visit: th-cam.com/play/PLX_1L8RY_Uz_7aPeXFi52OCFdSK03wUbT.html