Status column colour need to be change automatically

Rakesh Lavishetty
Rakesh Lavishetty ✭✭✭✭
edited 03/05/21 in Formulas and Functions

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.

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!