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!

Find more posts tagged with

Comments

Andrée Starå

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

Paul Newcome

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.

Lihi001

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...

Paul Newcome

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.

bzgryzek

there is a new workflow to lock a row once request has been approved but it does not work yet

Sign in to join the conversation!

Quick Links

Trending discussions

If you switch your Grid View to Table view, can and will your sheet stay as a table view permanently
I ask this question because i have switched my grid sheets before to table view and exited out of the sheet, then when i come back its back in grid view. Just wondering if thats normal. thanks
Request for Update Report (or something like it)
Hi there! I'm hoping this group can help. I'm building out program/project management & tracking at my company. We have 8 grids (one for each dept) that funnel into multiple reports and dashboards. Within each grid/sheet, there are multiple projects that have CHILDREN project plans nested underneath. We want project owners…
Change the owner of each item in Smartsheet
Hello everyone, I hope you’re doing well. Could you please share how to change the owner of each item in Smartsheet? Any detailed guidance or best practices would be greatly appreciated. Thank you