Need Formula for Automating RYGG Balls

Tera Westrick

I need help writing a formula that will change the color of the health RYGG balls depending on how close to the end date we are.

 

If end date is prior to TODAY, = Red

If (Today-Start Date)/(End Date-Start Date) is greater than or equal to 50% = Yellow

If (Today-Start Date)/(End Date-Start Date) is less than 50% = Green

If End Date is Blank = Gray

 

I keep messing my IF formulas up and it isn't working. 

 Help?

 

Tony Davidson - SmartSheet Certified User 2016

Hi Tera..did you figure it out?

Tera Westrick

I haven't... here is the link.  Project health column is the one i need the formula for that references today's date and start and end date columns.

 

 

http://publish.smartsheet.com/5cf090c2b82e4f9dbd00eccb266d45fc

Brett Evans

Publish the sheet to the web and gives us a look.