Approval request workflow with other cell dropdown
Hello,
I'd like to ask this great community how do I make a formula to work with an approval request, upon approved to update other cell in this row, which is a drop-down type for status (has more than 5 statuses).
i only like when the 'approved' received to updated status to 'Completed' but until then to have that cell open for manual change by the user and maintain the manual changes all they way util approved received...
any advice & feedback is great
Thanks!
Comments
-
Hi,
Unfortunately, that's not possible because as soon as you manually change the dropdown the formula to that changes to complete will be replaced.
I hope this helps you!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
One suggestion would be that you add another column called Completed. In that column you could enter a formula along the lines of
=IF(Approval@row = "Approved", "Completed", "")
This will automatically populate that column to "Completed" when the approval is received.
You could then create conditional formatting to change the Status column only to white font on white background if the column Completed is "Complete" which would essentially "hide" the Status column for that particular row.
-
Thanks!
but unfortunately this suggestion won't help since I plan to use the card view and like those cards to move automatically to completed column, creating new column will not show in this card view in my workflow...
-
If an additonal column won't work for your case then unfortunately your only two options would be full automation or full manual for the Status column.
-
there is a new workflow to lock a row once request has been approved but it does not work yet
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives