Рет қаралды 694
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...
View the original video, Timestamp with Checkboxes in Google Sheets: • Timestamp with Checkbo...
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.
** Note: you will need to select the appropriate cells where "C2 and D2" are.