RYG Balls Need a Little Help Please

Options

I have contacted the help desk and they suggested for me to post a question on the forum....


1. Get help with RYG Balls....


If start date is a date with no due date and at any % completed then yellow...

If due date is 3 days in the future then Yellow....

If due date is today Red......

if due date is tomorrow yellow .....

If due date is 4 days in the future then green or blue......

if no start or due date then blank......

If 100% complete with any or no start or due date then blank.....

with any due date in the FUTURE if % Completion is 50% - 99% then yellow

if 0% - 49% what ever it was originally.......

if due date in past at whatever % it is red....



Here is my code that I am using now but I am missing a few things.... Can you please look over my code and fix, change , help. Please.

PS. this is for the child rows if that info is needed.


IF(ISBLANK([Start Date]2), "Blue", IF([% Completion]2 <> 1, IF(TODAY() - [Due Date]2 > -1, "Red", IF(TODAY() - [Start Date]2 > -1, "Yellow", IF(TODAY() - [Due Date]2 > -3, "Yellow", "Green")))))



Thank you in advanced for all the help:)

Twyla

Best Answers

Answers

  • Genevieve, you are the most amazing. Thank you so very much. I have been trying to figure this out so we can move forward in sheets... You are great. Just to let you know looking over your code makes me understand how to do others. Great explanation. Thank you again.

    Twyla😀

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!