Field data changed by data entered in another field

I have a field that indicates the status as either Active or Inactive.
I also have a terminated date field. Is it possible to have the status field updated with “inactive” once a date has been entered the termination date field.


You may apply UPDATEIF() to achieve this.