Re: Summary Report and Color Coding or Rich Text Formula Field

Hi Joe,

We don't have any immediate plans to implement colorization in summary reports, but you can achieve a similar effect by using a Summary Formula and a Rich Text field. Here's an example:

var text red = "<a style=\" text-decoration: none; background: #ea4335; border-radius: 5px; color: #fff; display: inline-block; width: 80px; text-align: center; padding: 8px 20px; font: normal 700 14px/1 \"Calibri\", sans-serif; text-shadow: none; \">"&[number of issues] & "</a>";

var text green = "<a style=\" text-decoration: none; background: #34a853; border-radius: 5px; color: #fff; display: inline-block; width: 80px; text-align: center; padding: 8px 20px; font: normal 700 14px/1 \"Calibri\", sans-serif; text-shadow: none; \">"&[number of issues]&"</a>";

var text yellow = "<a style=\" text-decoration: none; background: #fbbc05; border-radius: 5px; color: #fff; display: inline-block; width: 80px; text-align: center; padding: 8px 20px; font: normal 700 14px/1 \"Calibri\", sans-serif; text-shadow: none; \">"&[number of issues]&"</a>";

var text gray = "<a style=\" text-decoration: none; background: #c2c2c2; border-radius: 5px; color: #fff; display: inline-block; width: 80px; text-align: center; padding: 8px 20px; font: normal 700 14px/1 \"Calibri\", sans-serif; text-shadow: none; \">"&[NUMBER OF ISSUES]&"</a>";

If([number of issues]=0,$gray,
(If([number of issues]<25,$green,
(If([number of issues]<=30,$yellow,$red)))))

And here's the output

------------------------------
Ryan Murray
------------------------------