Forum Discussion

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...

Ask about Quickbase functionality

reports and charts

QuickBaseCoachD

Qrew Captain

7 years ago

My solution is simple.

IF([Status]="Urgent", "<font color=red<b>" & [Status], [Status])

There are also formulas to color the background.

NirajShah4
Qrew Cadet
6 years ago
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
  Qrew Legend
  6 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
    Qrew Cadet
    6 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
    ------------------------------