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
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
Thanks
Comments
-
Leo,
Try
=IF([Compliance]5 = 1, 1, 0)
100% =1
50% = .5
-
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
Leo
-
Dear Leo,
You don't need "=" in the formula, just put =IF([Compliance]5 <1, 1, 0).
Is it what you mean?
Atus
-
excellent thanks you, it works a treat!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 304 Events
- 34 Webinars
- 7.3K Forum Archives