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.

Automate RYG (percentages)

08/30/17 Edited 12/09/19

Hi everyone, probably more of the same, but I cannot make my formula work... what I want is to change the color according to percentages in a different column, 0%to 33% Red, 34%to66%Yellow and 67% to 100% turn to green. 

I have used this formula, but is not working, any other thoughts around this?

=IF([% Complete]1<=33,"Red",IF(AND([% Complete]1>33,[% Complete]1<=66)=TRUE,"Yellow","Green"))

Thanks

Capture.JPG

Comments

  • Mike WildayMike Wilday ✭✭✭✭✭

    When numbers are formatted as percentages, then you need to reference them as portions of 1. Try this: =IF([% Complete]1<=.33,"Red",IF(AND([% Complete]1>.33,[% Complete]1<=.66)=TRUE,"Yellow","Green"))

    See if that works. 1=100%. 

  • Hi Mike, thanks for your answer, but still, this is not working... I've used your formula,  but I'm getting the same results: #UNPARSEABLE...

     

  • Mike WildayMike Wilday ✭✭✭✭✭

    Doh..  I didn't notice some extra text you had in there. I removed the =True part. Try this... 

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

  • Yeah!!! That's it, now is working, thanks for your help Mike... brilliant!

    Capture.JPG

  • Mike WildayMike Wilday ✭✭✭✭✭

    Glad I could assist! :) 

This discussion has been closed.