Symbols not changing based on the value in another cell

Options
Tauri
Tauri ✭✭
edited 12/09/19 in Formulas and Functions

Hi.

I have applied a formula where RYG "status" column is counting days to deadline and changes colors according to how many days are left till deadline (=IF(Done3 <> 3; IF(TODAY() - Due4 > -7; "Red"; IF(TODAY() - Due4 > -14; "Yellow"; IF(TODAY() - Due4 < 6; "Green"))))

Now i want to add another formula to column(Drop Down) called "Progression", where based on the RYG status column, "Progression" column(Drop Down) will change as Red = Escalate, Yellow = At Risk and Green = In Progress.

I tried following formula, but it doesnt work: =IF(Status4 = "YELLOW"; (Progression4 = "At Risk"))

 

Thanks

Tauri.

Tags:
· Share on FacebookShare on Twitter

Comments

  • Shaine Greenwood
    Shaine Greenwood Employee
    Options

    Hi Tauri,

    Try this:

    =IF(Status4 = "Red"; "Escalate"; IF(Status4 = "Yellow"; "At Risk"; IF(Status4 = "Green"; "In Progress)))

    · Share on FacebookShare on Twitter
  • Tauri
    Tauri ✭✭
    Options

    Hi Shaine.

     

    Thanks. Tried to copy/paste, but no luck. Then changed the order of the colors from "green" to "red" and voila, It worked.

     

    =IF(Status4 = "Green"; "In Progress"; IF(Status4 = "Yellow"; "At Risk"; IF(Status4 = "Red"; "Escalate")))

     

    Appreciate your support.

    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!