How to change status of first column when status changes in second column


I have a request come in and there is a first layer in the approval process. If the manager approves, it goes no further. If the manager denies the request, then the Associate Director investigates the problem, and will then submit his approval. I need HIS approval to change the first column status from "Denied" to "Approved". I don't know which column should contain the formula. And I'm not sure where to begin on the formula itself. Please see picture below.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!