Use a checkbox to clear another field


Is there a formula that could use a checkbox (when it’s value is 1) to clear the contents of another field in the record?
Basically I want to create a way to keep the record, which is a cue in a show, but clear a few fields where notes and assignments are marked, when that cue is approved.


I don’t think you can clear a field directly without using something like Zapier.

Apart from that, the best you could do is use a formula field that displays the original field unless the checkbox is ticked.

IF( {Check Box}=1, BLANK(), {Original Field} )


Thanks David - this makes sense and is helpful!