What formula to show if Green, In Progress

Justin G

Hello,

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

heyjay

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".

heyjay

https://community.smartsheet.com/discussion/119605/what-formula-to-show-if-green-in-progress

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", 
""))))

You can refer to this documentation for more information.

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

Justin G

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", ""))))

heyjay

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".

Justin G

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