Need to check and uncheck a box based on a percentage being above 0 and less than 100.

SmartSheet Newbie

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))

Nic Larsen

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

Nic Larsen

@SmartSheet Newbie

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.

Nic Larsen

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

SmartSheet Newbie

That worked but I am unsure why. Thanks!!

Nic Larsen

@SmartSheet Newbie

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.