Formula to uncheck a box
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
Answers
-
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
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives