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