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

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

Find more posts tagged with

Accepted answers

All comments

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.