Jan 21, 2019 12:51 PM
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.
Jan 22, 2019 02:07 AM
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} )
Jan 22, 2019 10:11 AM
Thanks David - this makes sense and is helpful!