Why won't my yellow indicator show up?
I'm evaluating a field to see if it's greater than 5 days..
=IF([S1-W0]@row > 6, "Red", IF(AND([S1-W0]@row = 5, [S1-W0]@row < 5), "Yellow", "Green"))
This is the formula I'm using. It will show red and green but if it's = 5 days, it still shows green.
Would someone please show me what I'm doing wrong.
Thanks
Michelle
Answers
-
Hi @Michelle Barnett
Hope you are fine, please try the following formula
=IF([S1-W0]@row > 6, "Red", IF([S1-W0]@row <= 5, "Yellow", "Green"))
but please note that your formula will show Green only when [S1-W0] = 6
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
-
Hi Bassam,
Thank you for getting back to me. I got an unparseable error, when I entered the formula, but I see that it worked for you in the example above. I just cut and pasted it, I'm not sure why it doesn't work.
Michelle
-
Please check your column type, and if you like share me as an admin on a copy of you sheet after you remove any sensitive data.
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 462 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!