Update column based on the changed value of another column
To set value based on other columns, see this KB
Basically you need to create an event handler using add_event().
More on event handler: https://phpgrid.com/example/custom-event-handler/
For custom validation rule, use set_col_customrule() function. Please see