How to Focus on One Thing

<div>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&nbsp;<br>0:16 another tab, we want to create another tab that has only the that is left unchecked. This is how you do it.<br>0:24 So we're going to start with an equal sign. Add New Task when Task Completed

We're going to go equals, we're going to do count all sheet one.<br>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.<br>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.<br>0:48 And this will give us a 6 here. Now how do we get this 6? Create a Sheet of Sheets for Project Management and/or Data Management Figure Out Frequency of Numbers SUM IF Fuzzy Search

This is telling us how many checks have been checked, meaning check boxes are just a representation of true or false.<br>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?<br>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.<br>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.<br>1:23 And we get an error . How can I count true and false? How To Count Checkboxes In Google Sheets

Because we need to have column one as well. So we need to type in index sheet one a colon a.<br>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.<br>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.<br>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.<br>1:58 So now we can only focus now we can focus on. Only one thing.</div> Figure Out Frequency of Numbers Add New Task when Task Completed