Background color expression

[#1]

Hi All,

I am creating a Projects Management Dashboard and for some reason I cannot get the background colors working when the expression looks like this

IF(STATUS = 'In-Progress' AND Now() = QTR_END OR STATUS = 'Not Started' AND Now() > Project_Due_Date, RGB(255,255,0)),
     IF(STATUS = 'Not Started' OR STATUS = 'In-Progress AND Now() > QTR_END OR Now() > Project_Due_Date, RGB(255,0,0)),
          IF(STATUS = 'In-Progress', RGB(0,255,0)

Am I missing something or can I get the colors with a different method?

Thank you.

[SunilChauhan]

it better to post a sample for us.

[Nicole-Smith]

You have some parentheses in the wrong places.  Corrected formula (for syntax errors anyway):

IF(STATUS = 'In-Progress' AND Now() = QTR_END OR STATUS = 'Not Started' AND Now() > Project_Due_Date, RGB(255,255,0),

     IF(STATUS = 'Not Started' OR STATUS = 'In-Progress AND Now() > QTR_END OR Now() > Project_Due_Date, RGB(255,0,0),

          IF(STATUS = 'In-Progress', RGB(0,255,0))))

[sudeepkm]

IF((STATUS = 'In-Progress' AND Now() = QTR_END) OR (STATUS = 'Not Started' AND Now() > Project_Due_Date), RGB(255,255,0),
     IF((STATUS = 'Not Started' OR STATUS = 'In-Progress) AND (Now() > QTR_END OR Now() > Project_Due_Date), RGB(255,0,0),
          IF(STATUS = 'In-Progress', RGB(0,255,0))))

[its_anandrjs]

Hi,

Use some thing like

IF(STATUS = 'In-Progress' AND Now() = QTR_END OR STATUS = 'Not Started' AND Now() > Project_Due_Date, RGB(255,255,0),

     IF(STATUS = 'Not Started' OR STATUS = 'In-Progress' AND Now() > QTR_END OR Now() > Project_Due_Date, RGB(255,0,0),

          IF(STATUS = 'In-Progress', RGB(0,255,0))))

You miss the single code in field STATUS

Hope this helps

Thanks & Regards

[#6]

I tried all these but it does not work even though there is no error in the script. Thanks for responding. I am still trying to get it to work.

[Anonymous]

Regardless the syntax and logic, I have a problem with

Now() = QTR_END

Now() is a timestamp, not a date.  This condition is virtually impossible to meet.  Maybe you mean

Today() = QTR_END

?

[#8]

Yes Michael, you are correct. Now() is always changing so can't use in if condition.