1 of 1 people found this helpful
Could you share your workbook? Meantime, try this:
IF attr[Corrective action exists]='No' AND attr[Due date (Act.)] > TODAY() THEN 'Red'
ELSEIF ([%Open] >= 5 AND sum[diff_date] < 30) THEN 'Yellow'
ELSE ' Green'
Hi Tushar ,
The workbook is confidential information for the corporation . Its a dashboard basically and I am editing a button I created there .
Also using ATTR on the first line made the calculation valid .
Have a good day!!