Status column colour need to be change automatically

Rakesh Lavishetty

colour.jpg

Here I have to apply formula for status coloumn,

If Actual hrs GREATER THAN Estimated hrs , i have to apply "Yellow" colour

EX : Actual hrs (10h) and Estimated Hrs (8h) = Yellow

if Actual hrs twice than that of Estimated hrs , i have to apply " Red" Colour

EX: Actual hrs (20h) and Estimated hrs (10h)= Red.

How do we accomplish this??

Thanks in advance.

Heather Duff

Hi Rakesh,

Try this:

=if([actual hours]@row>=2*[estimated hours]@row, "Red",if([actual hours]@row>[estimated hours]@row,"Yellow","Green"))

Because it tests the IF statements in order and stops once it reaches one statement that is true, you have to put the Red status first. That way, anything that has Actual hours 2x Estimated will be red first, then it will evaluate to see if the Actual is greater than Estimated; if not, it'll show green.

Let me know if this works for you!

Best,

Heather