Forum Discussion
QuickBaseCoachD
Qrew Captain
My solution is simple.
IF([Status]="Urgent", "<font color=red<b>" & [Status], [Status])
There are also formulas to color the background.
IF([Status]="Urgent", "<font color=red<b>" & [Status], [Status])
There are also formulas to color the background.
NirajShah4
5 years agoQrew Cadet
How would I be able to color code the values in the summary report based on a "status page" that is not seen on the summary report? In the image below, I want to color code the rows of the summary report based on a status field; Green = Done, Yellow = Pending, and Red = Overdue. Is this possible?
------------------------------
Niraj Shah
------------------------------
------------------------------
Niraj Shah
------------------------------
- MarkShnier__You5 years agoQrew LegendYou can't currently colour the rows, but you can create alternate Rich Text version of he first column (Task) and color that. Post back if you need help with the formula for that.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- NirajShah45 years agoQrew CadetThanks, Mark.
Do you mean that only the first column would be color coded with a hard coded color or a dynamic color? If the latter:
If I create the alternate rich text version of the first column (Task), could I base the rich text formula for that field based on the Status field? Or I could just create a rich text of the status field and have that as my first column on the report?
------------------------------
Niraj Shah
------------------------------- MarkShnier__You5 years agoQrew LegendThe best way would be to add a new group by column and used he std Quick Base images use the canned images as an extra group by in the summary report.
The images are here
https://login.quickbase.com/db/9kaw8phg?a=ShowPage&pageid=160
The formula would be a new Rich Text formula field called [Status icon]
Case([Status],
"Done", "<img src=https://images.quickbase.com/si/16/222-point_green.png>",
"Pending", "<img src=https://images.quickbase.com/si/16/223-point_yellow.png>",
"overdue", "<img src=https://images.quickbase.com/si/16/221-point_red.png>")
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------