Sign in to join the conversation:
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")
=IF([% Complete]3 < 50, "Red", IF([% Complete]3 = 100, "Green, IF([% Complete] >50 AND <100, "Yellow")
Corrected spelling error!
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")
Thanks Mike, but there is still something wrong: unparseable!
I have tried a dozen times with the same results!
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.
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.
Are you getting unparseable still?
=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!
Yes
#baldfromtearinghairout
Did this one work?
Green was missing a quotation mark!
I had a formula to list all distinct values from a column in another sheet. I was using this formula and it was working fine until last week. What could be wrong? =IFERROR(INDEX(DISTINCT({Liste de matériel Plage 1}); Séquence@row ); "") When I remove IFERROR, I get #INVALID DATA TYPE
i have 2 columns set up one is titled INS it has four dropdowns. the other is titled AMT, the amount in the amt column is dependent on the dropdown column selection which is text.
First off, I am using Control Center to build out projects that are dependent on a central worksheet, "Weeks of…" as a drop-down source list. The "Weeks of…" is contained in a Portfolio folder in the Admin workspace. Secondly, I have a worksheet, "Weeks" that contains a number of dates, DATE. In this worksheet I have an…
