We have a ticket level custom field called ‘Color’ which we use to track customer sentiment – tickets are marked red if the customer is upset, yellow if we feel that there’s a risk that they will be upset, and green if everything is copacetic.
I would like to run a search which displays this color field, and style the results with these colors – maybe with a box showing the color, or simply with the words ‘red’, ‘yellow’ and ‘green’ in their respective colors.
I tried messing around with this in the format section in the advanced search editor, the variables don’t mix well with the formatting.
Any ideas about how to do this?