Timestamp with Checkboxes in Google Sheets

[@kronen_bob]

HUGE help! I searched other ways and none of the functions worked until I found your video! Thank you for your videos.

[@LeanStrategiesInternationalLLC]

Glad it helped @kronen_bob If you are interested in more Google Workspace Content Please Visit This Great KZbin Playlist: kzbin.info/aero/PLX_1L8RY_Uz_hZNe3UX41-1zlUUasB9JW

[@icyherenow]

Others said it can only be done with app scripts, but you’re amazing-you actually achieved it directly with a formula. So impressive!

[@ZoyaBaranovskaya]

Wooow🎉great,brilliant solution! Without difficult scripts and soooo simple❤ thank you sooo much 😊

[@LeanStrategiesInternationalLLC]

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: kzbin.info/aero/PLX_1L8RY_Uz_7aPeXFi52OCFdSK03wUbT

[@BIGjeffSanDiego]

Perfect! So helpful! Thank you!

[@marylepage960]

Thank you for making this video! I've wanted a function like this for a while

[@LeanStrategiesInternationalLLC]

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 KZbin Playlist: kzbin.info/aero/PLX_1L8RY_Uz_hZNe3UX41-1zlUUasB9JW

[@PBTophie]

This works a treat! After writing a script that didn't work perfectly, this was all I needed. Hilarious. Thanks a million!

[@LeanStrategiesInternationalLLC]

We are happy to help. If you're interested in more Google Workspace Tips Please Visit the Link Here: kzbin.info/aero/PLX_1L8RY_Uz_hZNe3UX41-1zlUUasB9JW

[@StellaCOBB-m3c]

Thank you sir. You've just saved my day!!

[@LeanStrategiesInternationalLLC]

Glad this helped! Please feel free to check out more of our #googleworkspace videos here: kzbin.info/aero/PLX_1L8RY_Uz_hZNe3UX41-1zlUUasB9JW

[@JessicaFrank-m9m]

Finally found an easy solution to this timestamp task. Thank you! Also, looks like the Fonz got into spreadsheets after Happy Days?

[@LeanStrategiesInternationalLLC]

⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⣀⣤⣤⣶⣶⣶⣶⣾⣿⣿⣿⣿⣿⣶⣶⣄⡀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀ ⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⣀⡴⠾⠿⠿⣿⣿⣿⣿⣿⣿⣿⣿⣿⠿⢋⠙⢿⠿⠿⠟⠓⠒⠤⢄⡀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀ ⠀⠀⠀⠀⠀⠀⠀⠀⢀⡴⠞⠁⣐⣒⣚⣿⣿⣿⣿⣿⣿⣿⠿⣿⠋⣠⣾⡃⢀⠳⠄⠤⠾⣦⣄⠀⠘⠦⣀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀ ⠀⠀⠀⠀⠀⠀⠀⣰⠏⣠⠞⠛⠉⠉⠉⠉⢩⣽⣿⠿⠿⡇⢀⣠⢸⣿⠿⡉⠉⣀⢴⣤⣴⣦⣽⣿⡇⢀⠈⠓⣄⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀ ⠀⠀⠀⠀⠀⠀⢸⣿⡞⠁⠀⢠⣴⠄⠀⣿⣶⣤⣤⣴⣶⣾⣿⣯⣾⣿⣷⣦⣼⣿⣿⣿⣿⣿⣿⣿⣿⣏⠀⠀⠀⢃⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀ ⠀⠀⠀⠀⠀⠀⢸⣿⣼⣦⡔⠋⣡⣴⡦⠀⠉⠛⠛⠛⠉⣉⣽⣿⣿⣿⣿⣿⣿⣿⣿⣿⣿⣿⣿⣿⣿⣷⣷⠿⢋⡀⣇⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀ ⠀⠀⠀⠀⠀⠀⢸⣿⣿⣿⣷⣾⣥⣤⣤⣶⣿⣿⣶⣶⣶⣴⣿⣿⣿⣿⣿⣿⣿⣿⣿⣿⣿⣿⣿⣿⣿⣿⣿⣷⣾⣷⣜⠛⣄⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀ ⠀⠀⠀⠀⠀⠀⠀⣿⢿⣿⣿⣿⣿⣿⣿⣿⣿⣿⣿⣿⣿⣿⣿⣿⣿⣿⣿⣿⣿⣿⣿⡿⠿⠿⠿⢿⣿⣿⣿⣿⣿⣿⣿⣄⠘⣆⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀ ⠀⠀⠀⠀⠀⠀⠀⢸⡟⢿⣿⣿⣿⣿⣿⡿⠋⠉⠛⠻⠿⢿⣿⣿⣿⠿⠿⠛⠋⠉⠀⠀⠀⠀⠀⠀⠸⣿⣿⣿⣿⣿⣿⣿⣧⢈⣆⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀ ⠀⠀⠀⠀⠀⠀⠀⣸⡷⠂⡍⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠺⣿⣿⣿⣿⣿⣿⣿⣿⢸⡄⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀ ⠀⠀⠀⠀⠀⠀⣰⠟⠂⠀⡇⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠙⣿⣿⣿⣿⣿⣿⣿⣿⡀⢇⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀ ⠀⠀⠀⠀⠀⠀⡇⢀⣲⣾⡇⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⣿⣿⣿⣿⣿⣿⣿⣿⣷⢸⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀ ⠀⠀⠀⠀⠀⠀⡇⠀⢭⣹⣷⡄⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⢀⠀⣀⣠⣤⣴⣦⣤⡀⠀⠀⠀⠀⠈⢿⣿⣿⣿⣿⣿⣿⡿⢸⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀ ⠀⠀⠀⠀⠀⠀⡇⢰⣽⣿⣿⣧⠀⠀⠀⠀⢀⣀⠀⠀⠀⠀⠀⠀⠀⠸⠼⠿⠿⠿⣿⡿⠿⠿⠛⠳⠄⠀⠀⠈⢿⣿⣿⣿⣿⣿⣟⣸⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀ ⠀⠀⠀⠀⠀⠀⠸⣿⣿⣿⣿⣿⠀⠀⣰⣿⡿⡿⠷⠆⠀⠀⠤⠄⠀⢀⣠⣴⣾⣿⡿⣿⡿⣿⣷⣦⠀⠀⠀⠀⠘⣿⣿⣿⣿⡿⠟⢰⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀ ⠀⠀⠀⠀⠀⠀⠀⠹⣿⣿⣿⣿⡇⠾⣿⣟⣰⡾⢿⣿⣿⣦⠀⠀⠀⠛⠻⠹⠛⠈⠛⠛⠁⠌⠋⠛⠂⠀⠀⠀⠀⢿⣿⣿⣿⣷⠚⢸⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀ ⠀⠀⠀⠀⠀⠀⠀⠀⠙⣿⣿⣿⣧⠀⠼⣿⠏⠛⠟⠁⠈⠁⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⣼⣿⣿⣿⣿⡧⢸⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀ ⠀⠀⠀⠀⠀⠀⠀⠀⠀⠈⠻⣿⣿⠀⠀⠈⠒⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⣿⣿⡿⣹⠟⠁⡞⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀ ⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⢻⣿⡇⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠹⠿⠧⠅⠀⢠⠃⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀ ⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠈⢹⠃⡀⠀⠀⠀⠀⠀⠀⢠⠀⠀⠀⠀⠀⠀⢀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⣆⠀⡠⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀ ⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠁⠸⣷⡀⠀⠀⠀⠀⠀⠸⠀⠀⠀⠀⢀⣀⣀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠹⣿⡆⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀ ⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠸⠷⡄⠀⠀⠀⠀⠀⠈⠒⠾⣾⠏⠉⠁⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⢠⠀⡏⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀ ⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⢻⣆⠀⠀⠀⠀⠀⠀⠀⢠⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⣾⠀⡇⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀ ⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠈⣿⡆⠀⠀⠀⠀⠀⢀⣈⣀⣠⣤⣤⣤⣤⠼⠛⠷⠄⠀⠀⠀⠀⠀⣸⡿⠀⢀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀ ⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠸⣷⠀⣠⠾⠶⠾⠛⠛⠛⠋⠉⠀⠉⠁⠀⠀⠀⠀⠀⠀⠀⠀⣼⣿⠇⠀⢸⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀ ⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠘⢷⣄⡀⠀⠀⢀⠐⣺⡖⢛⣥⣴⡂⠀⠀⠀⠀⠀⠀⢠⣾⣿⠏⠀⠀⠀⢨⣓⠤⣀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀ ⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠈⣿⣷⠀⠀⠀⠽⠟⠛⠛⠉⠉⠀⠀⠀⠀⠀⠀⣴⣿⣿⠋⠀⠀⠀⠀⠸⣿⣿⣶⣝⡢⣀⠀⠀⠀⠀⠀⠀⠀⠀ ⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⢀⠅⠙⢧⡀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⣠⣾⣿⡿⠁⠀⠀⠀⠀⠀⠀⠈⢻⣿⣿⣿⣦⡑⢄⣀⡀⠀⠀⠀⠀ ⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⡠⠊⡆⠀⠈⠳⢦⣄⣀⡀⠀⠀⠀⠀⣀⣴⣾⣿⣿⡿⠁⠀⠀⠀⠀⠀⠀⠀⠀⠀⢹⣿⣿⣿⣿⣦⡀⠀⠉⠒⠤⡄ ⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⣠⠊⠀⣸⣧⠀⠀⠀⠀⠈⠉⠛⠳⢶⣶⣿⣿⣿⣿⣿⡿⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠘⣿⣿⠙⣿⣿⣿⣶⠦⠄⠀⠀ ⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⢀⠜⠁⠀⠤⣿⣿⠀⠀⠀⠀⠀⠘⠦⣄⣀⠈⠻⣿⣿⣿⡿⠁⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⣿⣿⠀⠈⢿⣿⣿⣷⣶⣶⡆ ⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⢀⠠⠚⢁⡀⠀⢠⣼⣿⣿⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⢻⣿⡟⠁⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⣿⡏⠀⠀⢸⣿⣿⣿⣿⣿⡇ ⠀⠀⠀⠀⠀⠀⠀⠀⠀⢀⠔⠁⠀⢠⡞⠀⠀⣸⣿⣿⣿⡆⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠉⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⢠⡟⠀⠀⠀⠈⣿⣿⡿⠿⢿⡇ ⠀⠀⠀⠀⠀⠀⠀⢀⣠⢎⢌⡄⢠⡾⠋⠀⠀⣿⣿⣿⣏⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⢀⡴⠋⠀⠀⠀⠀⠀⣿⣿⣿⡷⢼⡇ ⠀⠀⠀⢀⠠⠐⣨⢡⠄⣎⡾⢀⣼⡇⠀⠀⠀⣿⣿⣿⠻⣆⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⢀⣠⠴⠋⠀⠀⠀⠀⠀⠀⢰⣿⣿⣧⡘⣻⡇ ⠤⠒⠊⠁⣀⣴⣷⡏⡜⣼⣿⣿⣿⠃⠀⠀⠀⢸⣿⣿⠀⠈⠣⣄⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⣀⣤⠴⠞⠋⠁⠀⠀⠀⠀⠀⠀⠀⠀⢸⣿⣿⣿⣷⣽⡇ ⠀⣀⣴⣾⡿⣿⡟⣰⠙⡿⢸⣿⠃⠀⠀⠀⢀⣸⣿⣿⠀⠀⠀⠈⠙⠲⠦⠤⣤⣤⣄⣀⣀⣤⡤⠴⠶⠚⠋⠉⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⢸⣿⣿⣿⣿⣿⡇ ⢈⣉⣤⣤⣶⡿⢱⠃⣾⡇⢿⠃⠀⠀⠠⠚⢁⣿⣿⣿⡄⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⢸⣿⣿⣿⣿⣿⡇

[@karolpaz4090]

Perfect video, thanks so much!

[@LeanStrategiesInternationalLLC]

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: kzbin.info/aero/PLX_1L8RY_Uz_7aPeXFi52OCFdSK03wUbT

[@Robi01-x6t]

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 .

[@LeanStrategiesInternationalLLC]

Thank you for asking @user-uf3ol7kc4v. It looks like your formula would update everyday. Try watching the video (kzbin.info/www/bejne/d6SqqqKhfJt8irssi=5snaA7c5SmbK3vKl) and adjusting your formula based on the video. Please note the cell references that you use may be different from the video.

[@shotgunheist6536]

big thanks

[@LeanStrategiesInternationalLLC]

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: kzbin.info/aero/PLX_1L8RY_Uz_7aPeXFi52OCFdSK03wUbT

[@ikatefx]

Thank you!!

[@LeanStrategiesInternationalLLC]

You're Welcome! Please feel free to check out more of our #googleworkspace videos here: kzbin.info/aero/PLX_1L8RY_Uz_hZNe3UX41-1zlUUasB9JW

[@migueljaballas81]

Big help man!

[@LeanStrategiesInternationalLLC]

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: kzbin.info/aero/PLX_1L8RY_Uz_7aPeXFi52OCFdSK03wUbT

[@icyherenow]

you saved my life oh my God

[@GabrielAmarodeAlmeida]

When i type , after false the word false change to black insted of stay in blue.

[@LeanStrategiesInternationalLLC]

Thanks for sharing this. You might want to re-check your formula.

[@WarmApplePye]

My date keeps showing 30th December 1899?

[@LeanStrategiesInternationalLLC]

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: kzbin.info/aero/PLX_1L8RY_Uz_7aPeXFi52OCFdSK03wUbT