00:00Let me show you how you can obtain a date timestamp each time you check a checkbox like
00:03this.
00:04You might be thinking, this is an easy solution, you're going to use ifs, b2 equals false,
00:09is blank, b2 equals true, is now.
00:12Then after that hit enter, and then apply to a few rows, the same formula like this.
00:17And then if you place a check here, you can see the date timestamp coming in.
00:22But if you click another checkbox, you can see that the date time actually refreshes.
00:27And you click the next one, you can see the date time actually refreshes.
00:31This is an undesirable effect because you want to maintain the integrity of the original
00:36checkbox of when it was checked.
00:38So let me uncheck this, and show you how you can modify the existing formula.
00:44So you're going to change b2 to c2, and basically you're going to look for blank, if it's blank,
00:50you're going to show now as a date now itself.
00:54And here you're going to say if it's true, you're going to basically reference it back
00:59to c2 just like that, and hit enter.
01:02Now you're going to apply the same formula to the rest of the rows like this.
01:08Now if you were to put a checkbox here, you can see that it comes up with a pound reference
01:13exclamation error.
01:15This is how you resolve it.
01:16Go to file, go settings, go to calculation tabs, and in here you're going to say off to
01:23on to turn on the iterative calculation, and go save settings.
01:28Now I'm going to toggle this just to refresh it.
01:31And you can see it's got a date timestamp of 12, 11, and 6 seconds in the AM.
01:37If you click the next one, you can see that the original timestamp for this, the first
01:42checkbox is maintained, and you keep checking the next one, you can see that it's not refreshing
01:48anymore.
Comments