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
-
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)
Answers
-
How does the [Approval Status] get populated initially?
-
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.
-
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, Thank you so much! That worked out just the way I needed it to!
Blessings,
Kitty Sandel
-
Happy to help! 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!