How do I set Checkbox to "Selected" based on a value of another cell without overriding the formula

David Jasven

I am creating a Task Smartsheet.

The "Done" column is a checkbox field.

When "Done" is selected, an approval workflow is triggered.

If declined, I want the checkbox to become UNCHECKED, however I find that when doing this, I loose the formula that makes the checkbox to become unchecked therefore making the who process useless.

Any Ideas?

This is the formula i was using in the checkbox field

=IF([Creator Decision]7 = "Declined", 0, 1)

https://www.youtube.com/embed/wFQSP4xWGIY

Andrée Starå

Hi David,

Answering here as well.

Unfortunately, it's not possible at the moment to keep the formula in a cell when something is changed manually, but it's an excellent idea!

Please submit an Enhancement Request when you have a moment

As a possible workaround, you could:

• Use so-called helper columns that you can check, and then the Done column would update accordingly.
• Use a 3rd party service/integration like Zapier or similar to automate if it should be checked or not

Would any of those options work/help?

I hope that helps!

Be safe and have a fantastic week!

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!

David Jasven

Hi Andrée 

Thanks for the reply.

I would like to use a helper cell since the volume of tasks could make it expensive using Zapier.

My issue is that how am I able to use a helper cell to Update a cell in one column based on another columns value.

I just don't seem to find a way possible to do that. Maybe there is another way. Just to simplify what I need to try achieve.

If Column A = "Declined" and

If Checkbox in Column "C" is true

Then set checkbox in column "C" to false

I would like to put the above formula in Column C (helper column)

Is there a possible formula that can achieve this ?

Stay Safe and nice to meet you !!