Is it Possible to automatically update choice column based on multiple YES/NO or Date Column's

I am seeking support for create an automatically update choice column based on multiple YES/NO or Date Column's, so as different stages of the asset shipment is processed that Asset Status Value is C...