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: [ Ссылка ]

Want to sign up for more advanced features on google #workspace and help the channel out? Visit: [ Ссылка ]

You can learn more about Google Sheets Here: [ Ссылка ]

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: [ Ссылка ]

** Note: you will need to select the appropriate cells where "C2 and D2" are.

свернуть