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

How to show each child row item on a separate line in a generated PDF?
Hi! I’m trying to create an invoice using Document Builder. I saw a video where they had a parent row with child rows underneath, and the child row items appeared in the generated invoice as separate lines. In the comments, they mentioned that Document Builder only generates from one row, so the child row data needs to be…
How to set up a rule depending on what is selected in a previous column
How can I set up instructions from an earlier coloumn, if someone has selected Bonus A this means that a payment is due 6 months after the start date so need to show this date in the column
Combine Contact Lists
Hello. I am trying to combine contact list A with the Created By column into one Contact Helper column to use in order to restrict the user view in Dynamic View. Here is my problem. Contact List A is filled in from a form submission. The user is supposed to enter or select their email address along with the emails of any…