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

Tim_O_Neill
Participant II

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

0 3 542
3 REPLIES 3

RezaRaoofi
Participant V

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
Participant II

@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
Participant V

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

Top Labels in this Space