color coding - multiple types of fields
Can anyone help with the following color-coding formula? I couldn't find an example in the help guide of different types of fields in one formula. The first field is multiple choice and I only want...
Forum Discussion
What happens if all checkboxes are true? What color should it be? Or if it says Option 2 and Checkbox 1 is true? What color should it be?
------------------------------
Mike Tamoush
------------------------------
------------------------------
Mike Tamoush
------------------------------
- I read somewhere that the topmost color should take precedence, and they are listed in order of importance. This is how it was working for me before (when all four fields were checkboxes).
I was using this code before:
Case(true,
[Checkbox Field 1],"#f0f0f0",
[Checkbox Field 2],"#dbfffd",
[Checkbox Field 3],"#ffebbf",
[Checkbox Field 4], "#ffffbf"
)
------------------------------
Ashley Gwozdz
------------------------------- Ok yes order will be from top to bottom. In this case, since you are looking at multiple fields, you need an if statement.
If(
[Multiple Choice Field] = "Option2", "#f0f0f0",
[Checkbox Field 1] = true, "#dbfffd",
[Checkbox Field 2] = true, "#ffebbf",
[Checkbox Field 3] = true, "#ffffbf"
)
As soon as it hits a true statement, that is the color that will be used.
------------------------------
Mike Tamoush
------------------------------- Thanks! Works perfectly!
------------------------------
Ashley Gwozdz
------------------------------
