Timestamp with Checkboxes in Google Sheets
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: / @leanstrategiesinternationalllc
Want to sign up for more advanced features on google #workspace and help the channel out? Visit: https://www.leanstrategiesinternation...
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 with Checkboxes in #go...
** Note: you will need to select the appropriate cells where "C2 and D2" are.