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

(Tim O'Neill) #1

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??

(Reza Raoofi) #2

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) #3

@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”)

(Reza Raoofi) #4

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