Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Formula for RYG based on % complete
Comments
-
Hello,
I noticed a few things about your formula:
- Don't wrap numbers in quotes, only text.
- Percentages in Smartsheet are treated as decimal values between 0 and 1.
- I don't think you need the "" (return nothing) at the end. The formula will return nothing by default if none of the IF statements are met.
With the above in mind, try a formula like this:
=IF([% Complete]4 = 1, "Green", IF([% Complete]4 = .5, "Yellow", IF([% Completed]4 = 0, "Red")))
-
Thank you, I figured that out and was trying to delete my post when I saw yours! I appreciate it. I also saw a previous post of yours that is much more complex factoring in dates, which at some point I want to incorporate. We need to learn Smartsheet first. Signed up today!
This discussion has been closed.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives