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.
I've read all of the other posts about this formula, including the Blog, but i can't seem to get this formula right. Here's what I'm trying to do:
Due Date TODAY(-5) = Green
Due Date TODAY <4>0 = Yellow
Due Date TODAY+1 = Red
Date Completed = Blue
I can get the RYG balls but I can't figure out how to ADD the criteria for the Blue ball.
RYG =IF(TODAY() - Due2 > 0, "Red", IF(TODAY() - Due2 > -3, "Yellow", "Green"))
I can get the formula for JUST the blue ball: =IF([Date Completed]1 >= TODAY(), "Blue") but I can't figure out how to incorporate this into the RYG formula. What operator should I be using? What am I doing wrong? Any help is greatly appreciated.