As mentioned before here a listener Bot will work or a formula field and a conditional update is also possible.