How to keep a function in a cell after selecting a value from a drop-down

Sid Richardson

Hi Everyone,

I'm starting on Workflows now and I have a column called STATUS with drop-down values of Open, Sent for Approval and Closed. Additionally I want this formula on the STATUS column - If the Review Step Approval, set to Approved otherwise Closed. So I when the Approver, approves the work (The workflow logic sets the Review Step Approval Column to Approved), I want SS to look at that column and then automatically set the STATUS to Closed.

When I select Sent for Approval in the STATUS column drop down, SS keeps removing the formula. :(

Help!

Andrée Starå

Hi @Sid Richardson

Unfortunately, it's not possible have a formula and change the value manually without deleting the formula, but it's an excellent idea!

Please submit an Enhancement Request when you have a moment

There might be a workaround. Is that an option?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!