Hi Team,
I'm attempting to build a formula that requires three parts (I Think). The attachment below demonstrates in simple terms. When the production manager enters the date ("90 Day Defects Period") and clicks on the drop list ("PRODUCTION Job Status" and choose ("DEFECTS 90") the 90 days period will kick in. I want to track this automatically, I will do this by entering another row which capture dates and returns a word "Red" or "Orange" when those dates are reached from the (90 Day Defects date chosen.
i.e. =IF(ISDATE([90 Day Defects Period]1), DATE(YEAR([90 Day Defects Period]1), MONTH([90 Day Defects Period]1) + 1+1, >30 = "red", > 60 = "Orange", > 7 ="Green".
"90 Day" row will return Red, Orange, Green Then "(90 Day Defects") cell will use the conditional formatting will change color to that color giving us a view when the jobs are at with this.
My attempt at starting below....Don't laugh Craig.... haha
=IF(ISDATE([90 Day Defects Period]1), DATE(YEAR([90 Day Defects Period]1), MONTH([90 Day Defects Period]1) + 1, 30), ""),IF(AND(ISDATE([90 Day Defects Period]1),[PRODUCTION Job Status]1="DEFECTS 90", DATE(YEAR([90 Days Date]1), MONTH([90 Days Date]1) +1, 90), "")
