what is the formula, for red, blue, yellow and green

Madeline Hunter

Please provide the formula for red, blue, green and yellow for the status column

James Keuning

The answer is going to depend on your parameters, and what you are color status relates to. Time, money, weight, gpa, etc.

You are basically creating some nested IF statements to test conditions, and move to the next test if the condition fails.

I'm sure some can help with specifics if you provide some.

Here is an example:

https://community.smartsheet.com/discussion/80101/need-correct-syntax-for-if-and-logical-and-to-properly-set-the-status-to-blue-red-yellow-green