I should know this, but don’t … is there a method using an IF statement to set the value of another field?
Ex: IF(Status = “This”, OtherField="", OtherField)
This is if I set the Status field to one thing, the OtherField is cleared, otherwise it remains whatever value is present.