Hi How can I get a Colour Code column to sho...

[Tim_O_Neill]

Hi

How can I get a Colour Code column to show a colour dependant on the answer selected from a list a status column.

Eg if status = in progress I want the colour code to = Orange??

[RezaRaoofi]

Are you using Color column type? If yes, then you could use a formula like this in its App formula: SWITCH([Status],“In progress”", “Orange”, “Complete”, “Blue”, “DefaultColorName”)

[Tim_O_Neill]

@RezaRaoofi Thanks, I cannot get it right though.

What I want is

Not Started = Yellow In Progress = Blue Issue Requiring Attention = Orange Completed = Green

My Status Column is a Enum My Colour Code Column is “Colour” type.

I thought it should have been SWITCH([Status},“Not Started”, Yellow", In Progress", “Blue”,

“Issue Requiring Attention”, “Orange”, “Completed”, “Green”)

[RezaRaoofi]

That SWITCH expression has a few quotation marks missing, and [Status} also has a typo; aside from that SWITCH(…) requires a last papameter as Default value; in your case a default color; perhaps the Color type allows blank “”, but I have not tried that.

You might also use IFS(…)if you want; check out this document for more details and examples: https://help.appsheet.com/expressions/expression-types/conditional-expressions