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

Kitty

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.

Paul Newcome

You would need to create an additional column. The current [Approval Status] column would be hidden, and in a new column you would enter a formula along the lines of

=IF(ISBLANK([UPDATED APPROVAL DECISION BY ASSOCIATE DIRECTOR]@row), [APPROVAL STATUS]@row, [UPDATED APPROVAL DECISION BY ASSOCIATE DIRECTOR]@row)

Paul Newcome

How does the [Approval Status] get populated initially?

Kitty

When the request comes in, it goes to the Logistics Manager for the first approval. It stays IN PROGRESS until she submits her decision from a drop-down menu.

Paul Newcome

You would need to create an additional column. The current [Approval Status] column would be hidden, and in a new column you would enter a formula along the lines of

=IF(ISBLANK([UPDATED APPROVAL DECISION BY ASSOCIATE DIRECTOR]@row), [APPROVAL STATUS]@row, [UPDATED APPROVAL DECISION BY ASSOCIATE DIRECTOR]@row)

Kitty

Paul, Thank you so much! That worked out just the way I needed it to!

Blessings,

Kitty Sandel

Paul Newcome

Happy to help! 👍️