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

Peggy Parchert

@Firebott

Hello. I would use an automation to uncheck the box when the % Complete is 100%. It would be a Sheet change automation to uncheck a box.

Hope this helps.

Peggy