Formula using <>
I'm trying to create a formula that will return a red, yellow, or green ball. I saw the below formula on someone else's comment a while back, but wasn't able to find it today. Right now my formula is:
=IF([Late Tasks]@row > 0.75 * [Total Tasks]@row, "Red", IF([Late Tasks]@row <> 0.5, "Yellow", "Green"))
Can someone tell me what the <> does in this formula?
Answers

<> is the same as "not equal"

Ah, ok. Thank you!

So in that sense, I am saying if the late tasks are greater than 75%, turn it red, if it is not equal to 50%, turn it yellow, if it doesn't apply to either, turn it green.
Is there any way to do a formula that says if it is between two numbers (.75 and .25) to turn it yellow?

I would suggest something like this...
=IF([Late Tasks]@row > 0.75 * [Total Tasks]@row, "Red", IF([Late Tasks]@row > 0.25, "Yellow", "Green"))
When nesting IF statements, they read from left to right and stop on the first true value. So if your first argument is greater than 0.75, then by default it must be less than 0.75 if it is moving on to the second IF. Since less than 0.75 is already implied by making it this far, we only need to specify greater than 0.25.

Oh, perfect! Thank you, Paul!

Happy to help! 👍️
Please don't forget to mark the most appropriate response(s) as "helpful" so that others searching for a similar solution can know that one may be found here.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 61.2K Get Help
 320 Global Discussions
 197 Industry Talk
 415 Announcements
 4.2K Ideas & Feature Requests
 126 Brandfolder
 153 Just for fun
 124 Community Job Board
 441 Show & Tell
 26 Member Spotlight
 1 SmartStories
 276 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!