Multi User Select Field Colorization
I am wondering if it is possible to colorize a multi-select field gracefully on a report. For example, I would like to assign each option in the field a color, but if two or more are selected I want a...
Forum Discussion
Correct (At least going this route), If you have a ton of options there are a few other ways, but multi select fields are tricky.
Here is a more complete formula for your example
Here is a more complete formula for your example
List(", ",
If(Contains([Name], "Jack"),
"<div style=\"font-size: 12pt; color:white;background-color:blue; width:100%; text-align:center; \">Jack</div>", ""),
If(Contains([Name], "Carol"),
"<div style=\"font-size: 12pt; color:white;background-color:red; width:100%; text-align:center; \">Carol</div>", ""),
If(Contains([Name], "Barbara"),
"<div style=\"font-size: 12pt; color:white;background-color:purple; width:100%; text-align:center; \">Carol</div>", ""),
If(Contains([Name], "Janet"),
"<div style=\"font-size: 12pt; color:white;background-color:yellow; width:100%; text-align:center; \">Carol</div>", "")
)- I am finding that multi select fields are a pain. This seems to be the only option in terms of assigning multiple people to one record though.
