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.