Need help on Checkbox if %Complete = 100% then Checkbox is Checked

David Chen

Checkbox is checked if %Complete = 100%

I received the error message on the following expression: =IF([%Completed]@row = 1, 1, IF(([%Complete]@row < 1, 0)

Vince Darrigo

Hi @David Chen

Try this: =IF([%Complete]@row < 1, 0, IF([%Complete]@row = 1, 1))

Make sure you've formatted the %Complete column as percentages also. In the event that your percentage can go over 100% (and you would still want the checkbox checked in that case) you would want to go with: =IF([%Complete]@row < 1, 0, IF([%Complete]@row >= 1, 1))

I hope this helps! Shamelessly looking for my first voted answer :D

Vince Darrigo

Hi @David Chen

Try this: =IF([%Complete]@row < 1, 0, IF([%Complete]@row = 1, 1))

Make sure you've formatted the %Complete column as percentages also. In the event that your percentage can go over 100% (and you would still want the checkbox checked in that case) you would want to go with: =IF([%Complete]@row < 1, 0, IF([%Complete]@row >= 1, 1))

I hope this helps! Shamelessly looking for my first voted answer :D

David Chen

Vince, It works. Thank you so much.