Welcome!

This Post is Archived and Read-Only

The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.

Browse Active Topics

Formula for RYG based on % complete

cochransj1

Trying to get RYG symbols for % completed on tasks. I am getting #UNPARSEABLE

=IF([% Complete]4 = "100%", "Green", IF([% Complete]4 = "50%", "Yellow", IF([% Completed]4 = "0%", "Red", " ")))

Can anyone please help?

Comments

Shaine Greenwood

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")))

cochransj1

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!

Sign in to join the Community!

Quick Links

Find more posts tagged with

Formulas