Forum Discussion

ToddMolino1's avatar
ToddMolino1
Qrew Cadet
7 years ago

Total Field or Column Header Colorization in a Summary Report

Hello,  I have a summary report shown below, 1 of 9 that I'm building. Each of these summary reports takes a particular set of Statuses and totals them. Each total OR column headers will need to be c...
App builders
Ask about Quickbase functionality
reports and charts
NirajShah4's avatar
NirajShah4
Qrew 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
------------------------------
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
5 years ago
You 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
------------------------------
  • NirajShah4's avatar
    NirajShah4
    Qrew Cadet
    5 years ago
    Thanks, 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
    ------------------------------