Setting other field values


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.