If Date is Passed, And Done, Hide Text

Learn how to hide overdue text in Google Sheets when a task is marked as done using a combination of IF and TODAY functions. This video builds on previous concepts to enhance your spreadsheet management.

In a previous video, I showed you how to show this overdue. What we're using here is a formula combination of if and today, as well as if and is blank. So we're making sure that we have a date and today is greater than the date there. But what happens if we click done? One simple way we can do that is we can hide this if, based on E2, this column. And if it's true or checked, we're going to put in nothing. So that's, we're going to leave that blank there between the two commas. And now it can be overdue, but if it's done, it won't show overdue. So that's a simple way to get rid of that overdue. Even if something is done, hopefully that was a good addition to that past video. I'll put a link to that past video down below for those who haven't watched it yet. Better Sheets Videos Checklist How To Hide Data with Checkboxes in Google Sheets How To Grey Out Unused Cells