If my status column is Complete, I want the ball to turn "blue"
Answers
-
I have a similar issue, If my status column is Complete, I want the ball to turn "blue"
This is the current formula and it works perfect:
=IF([Target End]@row <= TODAY() - 15, "Red", IF([Target End]@row <= TODAY() - 30, "Yellow", "Green"))
I tried to add the turn blue on complete, and can't get it to work.
=IF(STATUS@row = "Complete”, “Blue”, IF([Target End]@row <= TODAY() - 15, "Red", IF([Target End]@row <= TODAY() - 30, "Yellow", "Green")
-
The syntax of your formula is correct, but it looks like the quotes you're using may be the wrong type. See how there are two types of quotes around "Complete”?
The first is straight: " and the end one is curved: ”
Smartsheet needs the straight ones. You'll want to write the formula directly into the cell in Smartsheet so the correct quote types will automatically be used!
Try this:
=IF(STATUS@row = "Complete", "Blue", IF([Target End]@row <= TODAY() - 15, "Red", IF([Target End]@row <= TODAY() - 30, "Yellow", "Green")))
Cheers!
Genevieve
Join us for Jumpstart 2025 with Community on 23 January (in two time zones)! 🎉 Register here.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.1K Get Help
- 443 Global Discussions
- 140 Industry Talk
- 472 Announcements
- 5K Ideas & Feature Requests
- 129 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!