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!

Rob

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!