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??
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โ)
@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โ)
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
User | Count |
---|---|
61 | |
25 | |
14 | |
11 | |
6 |