True/False IF formula not working?

JWPMC

JWPMC ✭✭

11/15/23 in Smartsheet Basics

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.

Tags:

0 ·

Best Answer

Nic Larsen ✭✭✭✭✭✭

11/15/23 Answer ✓

@JWPMC
5% in a formula would be .05. Update your formula and it should work.

1 · Share on Facebook Share on Twitter

Answers

Nic Larsen ✭✭✭✭✭✭

11/15/23 Answer ✓

@JWPMC
5% in a formula would be .05. Update your formula and it should work.

1 · Share on Facebook Share on Twitter
JWPMC ✭✭

11/15/23

Thank you! That worked. Sometimes staring at the sheet for so long takes a toll on the brain lol

0 · Share on Facebook Share on Twitter

Categories

Trending in Smartsheet Basics

IF {Status} is "X" or "XX" and {Date} is in the coming 90 days
Hello, In the formula below I am asking if the status in a reference sheet is "Pending Submission" or "Pending Approval" then display "No" in a symbol column. I would be very grateful for any best practice on how to structure the formula to add in if {status} is "Pending Submission" or "Pending Approval" and a {Date…
Multiple Selection in drop down or buttons on forms
There should be a way to select multiple options on a form when choosing from a list.
Duplicate Rich Text Widgets to another dashboard
Hi, We have a project that has a SS dashboard with all the updates ("Master Dashboard"). We have another dashboard that would duplicate some of the RT widgets from the Master Dashboard. How can we do this automatically? Trying to avoid duplicated efforts for the same exact content. The content has some rich formatting, so…

Help shape the future of Smartsheet.
Share your ideas and feature requests.