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.
Негізгі бет Timestamp with Checkboxes in Google Sheets
No video
Пікірлер: 29