Hi there!
I have been trying to set conditions with a formula to change the color of a RYGB ball based on two columns, the percent complete and the due date. I wish to use the RYGB balls and not just change the color of the cell, which is why I'm using formulas instead of the conditional formatting. I keep receiving the UNPARSEABLE error.
Below is my current formula. Not sure if I have my status circle column setup incorrectly, or if there's a flaw in my formula. Tips on what I might be missing would be appreciated!
=IF([Percent Complete]6 < 100 AND(TODAY()>DATEONLY([Due Date]6)), "Red", IF([Percent Complete]6 < 85 AND(TODAY(-14)=DATEONLY([Due Date]6)), "Yellow", IF([Percent Complete]6=100, "Blue", IF([Percent Complete]6=100 AND(TODAY()=DATEONLY([Due Date]6)), "Green", IF(TODAY(14)<DATEONLY([Due Date]6)), "Green"))))
*Percent Complete and Due Date are columns with general number formatting and MM/DD/YY formatting, respectively. I am working on row 6, hence the [Column Name]6 notation.