Use a checkbox to clear another field


#1

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.


#2

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} )


#3

Thanks David - this makes sense and is helpful!