Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Auto Checkbox Completion

Leo Plant
Leo Plant
edited 12/09/19 in Archived 2016 Posts

Hi All,


I am trying to get a formula to work that checks a box based on a column with percentage. I.e when 100% is reached the box is checked.


I have tried the following to no avail


=IF([Compliance]5 = "100%", 1, 0)


Similarly I would like to have another column ticked if non compliant i.e <100% again I have tried

=IF([Compliance]5 = "<100%", 1, 0)


Any help would be great






  • JamesR
    JamesR ✭✭✭✭✭
    edited 02/16/16




    =IF([Compliance]5 = 1, 1, 0)

    100% =1

    50% = .5


  • Leo Plant
    Leo Plant
    edited 02/16/16

    Thanks James,


    That works great for the 100% forcing checking of the compliant column. How would I get the non compliant column to be checked if it is less that 100% comliance? I have tried =IF([Compliance]5 = <1, 1, 0) but that has not worked.


    Many Thanks



  • Atus Bartal
    Atus Bartal ✭✭✭✭✭
    edited 02/16/16

    Dear Leo,


    You don't need "=" in the formula, just put =IF([Compliance]5 <1, 1, 0).


    Is it what you mean?



  • excellent thanks you, it works a treat!

This discussion has been closed.