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