Forum Discussion

ToddMolino's avatar
ToddMolino
Qrew Cadet
5 years ago

Multi-Select Summary Colorization

I currently have a relationship between 2 tables, Questions and Evaluations. In the Questions table, I have a basic formula text field called "Result":
If(
[N/A], "N/A",
[Not Compliant],"Not Compliant",
[Compliant], "Compliant",
"TBD"
)

I'm then summarizing these values up to the Questions table for a particular report as multi-select summaries:

This is what a portion of the report looks like:

My goal is to have the Not Compliant results show in red. 
I've tried to use a rich text field verses a text field for the "Result" and this does not seem to work. 

Anyone have any suggestions? Is this even possible? 

Thanks for any feedback!





------------------------------
TM
------------------------------
Formulas and functions
Relationships
  • ToddMolino's avatar
    ToddMolino
    Qrew Cadet
    5 years ago
    I went a different direction and worked out a solution.

    ------------------------------
    Todd
    ------------------------------