Formula to uncheck a box

Firebott

Hi all,

I have a project sheet that I need some help with a formula. The sheet has a checkbox called To-Do and a % Complete. All tasks start with the To-Do check box as unchecked. If the user needs the SME to act on that task, they check the To-Do box. I then have a report sent to each SME with their "To-Do" list. The SME then returns to the project sheet and updates the % Complete. What I need is: if the % Complete is 100%, then uncheck the box. What I am finding is the formula is removed when the user places the checkmark in the To-Do box. Can anyone think of another way to achieve the end result. Here is the formula I currently have: =IF([% Complete]@row = 1, 0).

Thank you

Philip Robbins

You could use an automation with the following logic:

When rows are changed and % Complete changes to 100%, clear a cell (that cell being To-Do). No formulas required then.

Philip Robbins

You could use an automation with the following logic:

When rows are changed and % Complete changes to 100%, clear a cell (that cell being To-Do). No formulas required then.

Firebott

I didn't even think of that as an option. I was so focused on a formula. Thank you so much @Philip Robbins