Automatically add a check to a checkbox cell if a cell is Not blank
Hi all. I've been trying to figure this one out by myself but I just cant seem to get it.
I have a column "Date Closed" and I want to have a checkbox in that row be automatically checked once a value (date) is added to the "Date Closed" cell. (and the checkbox empty if there is no Date Closed value).
I thought this would be simple. I have been playing with this simple formula. can anyone help?
=IF(ISBLANK([Date Closed]:[Date Closed]), 0, 1)
I also thought it would be easier to not deal with the NOT statement, so I just switched the condition at the end. am I on the right track?
Help Article Resources
Check out the Formula Handbook template!