True/False IF formula not working?
JWPMC
✭✭
I noticed that the formula I was using wasn't working so I moved it to a text column to see if the output is correct. Turns out the output is giving me 0, so no wonder the checkbox isn't checking!
My issue is that I'm trying to get a checkbox to check if the values are either -5 or 5. However, I'm stumped on what I'm supposed to do here to get this to work.
Best Answer
-
5% in a formula would be .05. Update your formula and it should work.
Answers
-
5% in a formula would be .05. Update your formula and it should work.
-
Thank you! That worked. Sometimes staring at the sheet for so long takes a toll on the brain lol
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.7K Get Help
- 438 Global Discussions
- 152 Industry Talk
- 497 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 509 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 307 Events
- 36 Webinars
- 7.3K Forum Archives
Trending in Smartsheet Basics
- Hi Everyone, I would like to create a weekly trivia game for my team members and my thought was to use a form to populate answers to the sheet. However, I don't want them to be able to see what other …
- Good afternoon, In reviewing the question that Nino Chkhikvadze posted on 7/30/20, and the response from Andree Stara, Community Champion, on the same date, would it be accurate to say that an unlicen…
