How to Hide Text Until Checkbox Checked

0:00 We want to hide some text until a checkbox is clicked, just like this. Yay. We've got this project done and we have a little message here. Yay. Or maybe next steps or what to do next. Make sure you submit it, that kind of thing. I'm gonna show you how to do this formula next to it, or actually in any cell or any column in this row. We can do equal sign. If we're gonna use the IF formula and the logical expression of a checkbox is literally just the reference to the checkbox . So we can click here on D two or we can type it in. D two, put a comma. And basically a check box is either true or false. So this first argument is going to be what happens when it's true or checked. We can put in this is checked and then a comma. Spreadsheet Automation 101 Lesson 2: If ( ){ } and Checkboxes How To Hide Data with Checkboxes in Google Sheets Create a Radio Button From Checkboxes Using Google Apps Script Conditional Formatting With Checkboxes in Google Sheets

0:46 And now we need to put in what to do when it's false or it's unchecked. You can put in nothing. We can just end parentheses here and it will just show up blank. Or we can put in some text. Let's put in arrow going this way and say, done yet. And now once it's clicked done, it changes to, this is checked so we can copy paste this all the way down. You can see it says done yet, but again, we don't need this third argument where it says false. We can just leave it blank and copy and paste that all the way down. And now every single one. Once it's checked, it says this is checked that's how to hide text until your checkbox is checked. If you're looking to get more out of your Google Sheets than you ever have before, subscribe here on YouTube to better sheets. Magical Things You Can do with Checkboxes in Google Sheets How To Create a Stop Watch in Google Sheets Uncheck Every Checkbox in Google Sheets How to Hide Cell Values Based on Checkbox or Dropdown