# What formula to show if Green, In Progress

Options
edited 03/26/24

Hello,

Looking to create a formula to return the below data. If Blue=Completed, yellow=not started, red=at risk, green=in progress. Thanks!

• ✭✭✭✭✭
Options

There is something wrong with the last set of arguements,

```=
IF(Status@130="Complete", "Blue",
IF(Status@128="Not Started", "Yellow",
IF(Status@127="At Risk", "Red",
IF(Status@129="In Progress", "Green", ""))))
```

Did you mean something like the one above? You need to replace the "Status@Row" with your column name. Keep the @row and just replace the "Status".

...

• ✭✭✭✭✭
Options

Hello Justin, you can use the actual color name in your formula.

```Icon =
IF(Status@row = "Complete", "Blue",
IF(Status@row = "Not Started", "Yellow",
IF(Status@row = "At Risk", "Red",
IF(Status@row = "In Progress", "Green",
""))))
```

https://help.smartsheet.com/articles/2480316-available-symbols-in-symbols-column

...

• Options

Thank you! So I came up with this formula but I get the error. What did I do wrong here?

=IF(Status@130="Complete", "Blue", IF(Status@128="Not Started", "Yellow", IF(Status@127="At Risk", "Red", IF(Status@129=[Priority Conversations Needed]133"In Progress", "Green", ""))))

• ✭✭✭✭✭
Options

There is something wrong with the last set of arguements,

```=
IF(Status@130="Complete", "Blue",
IF(Status@128="Not Started", "Yellow",
IF(Status@127="At Risk", "Red",
IF(Status@129="In Progress", "Green", ""))))
```

Did you mean something like the one above? You need to replace the "Status@Row" with your column name. Keep the @row and just replace the "Status".

...

• Options

Thank you, that helped! I noticed I was also missing the "[ ]" brackets before and after the Status. I got it to work now. :)

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!