how to clear a cell after you uncheck a box


I have a "Record a date" that populates in a cell when the completed box is checked. If, for some reason, that box is unchecked, how do I have the populated "Record a date" cell cleared?

The "Done" box was checked but if the task wasn't actually completed and the box was then unchecked, I need to have the "Completion Date" (which is a "Record a Date" automation) cleared. Is this possible?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!