Check Box Formula - Incorrect Argument
HI All
I have a formula that I am trying to write for a checkbox column. We have a "Meter" column and we want the checkbox column to be checked if the "Meter" column is 100% or less and not check if it is greater than 100%
We wrote the formula as
=IF(Meter@row, ="<=100", 1, 0)
Obviously it is wrong and I am sure it is a simple fix but need assistance to correct
Thank you
Best Answer
-
Hey @BESP10
Your syntax is not what smartsheet is expecting. Try this:
=IF(Meter@row <=100, 1)
Will this work for you?
Kelly
Answers
-
Hey @BESP10
Your syntax is not what smartsheet is expecting. Try this:
=IF(Meter@row <=100, 1)
Will this work for you?
Kelly
-
Hi @Kelly Moore
Thanks
I dont have the error message anymore, but all of the rows are checked off, even the ones that are greater than 100. How do I write it so that only values of 100 or less will get a check mark?
thanks
-
Hey @BESP10
I overlooked your 100% comment above. If your column format is percentage that means your data is in decimals.
=IF(Meter@row <=1, 1)
Try this
Kelly
-
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!