nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Welcome!

Trouble with RYG Formula:

Beth Blome

Can anyone tell me what I am doing wrong here? I am trying to automate RYG balls from a % column.

=IF([% Complete]3 < 50, "Red", IF([% Comlete]3 = 100, "Green, IF([% Complete] >50 AND <100, "Yellow")

Find more posts tagged with

Formulas

Comments

Beth Blome

=IF([% Complete]3 < 50, "Red", IF([% Complete]3 = 100, "Green, IF([% Complete] >50 AND <100, "Yellow")

Corrected spelling error!

Mike Wilday

Smart sheet displays the percentages as such, but in reality the backend is reading a decimal. When referencing perecentages in formulas you should use .5 for 50% and 1 for 100%. SO your formula would look like this...

=IF([% Complete]3 < .5, "Red", IF([% Complete]3 = 1, "Green, IF([% Complete] >.5 AND <1, "Yellow")

Beth Blome

Thanks Mike, but there is still something wrong: unparseable!

I have tried a dozen times with the same results!

Mike Wilday

Duh I should have looked more carefully! And statements should be made as indicated below...

=IF([% Complete]3 < .5, "Red", IF([% Complete]3 = 1, "Green, IF(AND([% Complete]3 >.5, [% Complete]3 <1), "Yellow")))

You also didn't have enough closing parenthesis.

Beth Blome

Maybe I have been staring at this too long! It still doesn't work. Did it work for you?

YOU are a peach, by the way. Thanks for helping.

Mike Wilday

Are you getting unparseable still?

Mike Wilday

=IF([% Complete]3 < .5, "Red", IF([% Complete]3 = 1, "Green", IF(AND([% Complete]3 >.5, [% Complete]3 <1), "Yellow")))

Green was missing a closing quotation mark!

Beth Blome

Yes

#baldfromtearinghairout

Mike Wilday

Did this one work?

=IF([% Complete]3 < .5, "Red", IF([% Complete]3 = 1, "Green", IF(AND([% Complete]3 >.5, [% Complete]3 <1), "Yellow")))

Green was missing a quotation mark!

Sign in to join the conversation!

Quick Links

Trending discussions

MAX Formula Cells Updating in Reports
We have two cells with 'planned start' and 'planned end' dates. We also have two cells for 'actual/revised start date' and 'actual/revised end date'. These are designed to allow managers to enter the estimated start/end date of a milestone, and the revised start and end date when things slip. The actual/revised end date…
COUNTIFS - count the number of dates that fall within one month
Hi Community! Hoping you can assist. Can you tell me what is wrong with this formula for counting how many publications that fall within one month? =COUNTIFS( [Publication Date]:[Publication Date], >=EOMONTH(TODAY(), -1) + 1, [Publication Date]:[Publication Date], <=EOMONTH(TODAY(), 0) ) The date in the Publication Date…
Cross-Sheet Formula Help
I have two sheets: the first sheet is called 'Source Sheet', and the second is called 'Helper Sheet'. I want to use the Helper Sheet to track survey responses that are fed into the Source Sheet. The formula should reference a column in the first sheet named 'Company Email'. If that column is not blank on the Source Sheet,…