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.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!