Clear cell data based on dropdown selection

Cam Swift
Cam Swift
edited 12/09/19 in Smartsheet Basics


I need to clear a date in a cell when a dropdown list selection is set to completed. This will then in turn remove the notifications from appearing and removed the conditional formatting used a visual tool.

Ive tested an IF statement on the date cell, by adding the IF statement, adding the date and then selecting the dropdown list option.

Is this even possible?