RYGB

so_tx_anglerette
edited 12/09/19 in Smartsheet Basics

I am trying to develop a formula that will look at multiple columns to return a RYG status.  

If "Sign work?" is box is checked

THEN

Look at "Sign projected ship date"  & "Sign actual ship date" compare to "Sign need date"

Here's where I'm not sure on the logic sequence:

If "Sign actual ship date" is null - Use projected to drive ball color

If the "Sign actual ship date" is later than the projected, use it to drive the color of the ball

If the "Sign actual ship date" is sooner than the projected, use it to drive the ball color

RYG symbol in column "Sign mfg status":

Red - Result is beyond or within 3 days of "Sign need" date  

Yellow - Result date is within 7 days of "Sign need" date

Green - Result date is within 14+ days of "Sign need" date

If "Sign work?" box is not checked, then the result is null

Maybe I am over complicating?

 

SS RYG Jaimes.PNG

Comments