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

Options

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)

Best Answer

  • Vince Darrigo
    Vince Darrigo ✭✭✭✭
    edited 06/09/24 Answer ✓
    Options

    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

Answers

  • Vince Darrigo
    Vince Darrigo ✭✭✭✭
    edited 06/09/24 Answer ✓
    Options

    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
    Options

    Vince, It works. Thank you so much.