0:00 Alright, you're staring at a list of a thousand things to do and you just want to do one thing. You want to focus on one thing and you're checking them off as you go, but you're like, after like a task 50 or 30 or something, you're like, oh, I need to just focus on one task at a So how do you see in 
0:16 another tab, we want to create another tab that has only the that is left unchecked. This is how you do it.
0:24 So we're going to start with an equal sign. We're going to go equals, we're going to do count all sheet one.
0:30 And we want to do sheet one a colon a, and that will give us everything. But that's not what we want to do.
0:37 That's a thousand. We want to count if. We want to do COUNTIF, sheet 1, A to A, the criteria being true.
0:48 And this will give us a 6 here. Now how do we get this 6? This is telling us how many checks have been checked, meaning check boxes are just a representation of true or false.
1:00 And this is telling us how many checks have been checked, meaning check boxes are just And this is telling us how many checks have been checked, meaning check boxes are just So how do we get this to actually show us task 7?
1:05 Well what we can do is take this, wrap it in index, and we're gonna wrap index and we're gonna go to index sheet 1, 8 to A as well.
1:16 We're gonna use this count if as the row going to go at the end and we're going to add plus one.
1:23 And we get an error. Because we need to have column one as well. So we need to type in index sheet one a colon a.
1:37 And we're going to use count if in the row. We're going to add plus one to it. And we're going to add plus one to it.
1:41 I'm going to use column 2 actually because we want the task name and we need to change it to A B and we get task 7.
1:48 So now we can focus on one thing here. And if we check off A 7 our one thing is now task 8.
1:58 So now we can only focus now we can focus on. Only one thing.