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.
Use a checkbox to clear another field
+14I 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} )
Reply
Most helpful members this week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.