Need to check and uncheck a box based on a percentage being above 0 and less than 100.
I have been trying different variations of the below but it always errors out until I start checking boxes and when the percentage reaches 100 the box is still checked.
The checkbox in question is in a column named Inprocess, and the percentage in in a column named Percent completed.
=IF([Percent Completed]@row > 0, true, false, IF([Percent Completed]@row < 100, true, false))
Best Answers

Try: =IF([Percent Completed]@row = 1, 0, IF([Percent Completed]@row > 0, 1))

If the % complete = 100% (which is a 1 in a formula), then uncheck which is a 0 value in a checkbox column.
If the % complete is greater than 0, check the box (which is a 1 value).
If % complete is zero, it will also be unchecked.
Answers

Try: =IF([Percent Completed]@row = 1, 0, IF([Percent Completed]@row > 0, 1))

That worked but I am unsure why. Thanks!!

If the % complete = 100% (which is a 1 in a formula), then uncheck which is a 0 value in a checkbox column.
If the % complete is greater than 0, check the box (which is a 1 value).
If % complete is zero, it will also be unchecked.
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63K Get Help
 379 Global Discussions
 213 Industry Talk
 442 Announcements
 4.6K Ideas & Feature Requests
 140 Brandfolder
 129 Just for fun
 130 Community Job Board
 449 Show & Tell
 30 Member Spotlight
 1 SmartStories
 305 Events
 34 Webinars
 7.3K Forum Archives