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

Notification Issue
Hi team, Was there an issue, or possible maintenance, that would have impacted notifications overnight last night (1/15 to 1/16)? My team saw delays up to 60 minutes on a couple of notifications that are typically sent within minutes, and at least one case where a notification still has not been sent. Notifications are…
Automation works when run manually, Doesn't run at all automagically.
Not sure what the secret to automation is but it's not working. What I'm trying to accomplish: Fill out form Data goes into sheet called Core Automation is triggered when new row is added which copies data to sheet called Bridge Rows 1-5 in Bridge contain default data I want to copy to Core Automation in Bridge is…
Date Formula Help Needed!
My current formula seems to count weekends and then also seems to count the day of as a day too - can someone help me rewrite this so days until due for 1/17/2025 would show as 1 and not 2, and then also skip weekends? Formula in case its hard to see below - =IFERROR(NETWORKDAYS(TODAY(), [Reporting Due Date]@row), "")

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