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
- Smartsheet Customer Resources
- 62.1K Get Help
- 352 Global Discussions
- 198 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 135 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 444 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!