Skip to content
  • Try Smartsheet

    • Smartsheet Basics

    Smartsheet Basics

    Ask questions about the core Smartsheet application: Sheets, Forms, Reports, Dashboards, and more.

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

    ✭✭
    in Smartsheet Basics

    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)

    · Share on FacebookShare on Twitter

    Best Answer

    • ✭✭✭✭
      edited 06/09/24 Answer ✓

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

      Check100plus.jpg

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

      · Share on FacebookShare on Twitter

    Answers

    • ✭✭✭✭
      edited 06/09/24 Answer ✓

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

      Check100plus.jpg

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

      · Share on FacebookShare on Twitter
    • ✭✭

      Vince, It works. Thank you so much.

      · Share on FacebookShare on Twitter

    Sign in
    Try Smartsheet

    Quick Links

    Categories

    Trending in Smartsheet Basics

    Help shape the future of Smartsheet.
    Share your ideas and feature requests.

     Watch video