CHANGE ON SITE AFTER IS CONFIRMED
I have a column “Equipment Order Status” that has a dropdown (Ordered, On Site, Shipped, Delivered) and another column “Equipment Confirmed Arrived” that has a dropdown (Not Confirmed, Confirmed). I would like when I choose from Equipment Confirmed Arrived” column the option “Confirmed” the column “Equipment Order Status” changes from whatever the status is to “On Site”. BUT I want to be able to use the dropdown in “Equipment Order Status” because when the status is “Delivered” I need to change the “Equipment Confirmed Arrived” to “Confirmed” when the site manager confirms he received.
I appreciate your help very much!