Get Expert Help

Quick Base Junkie Blog

Short videos and posts to skyrocket your Quickbase skills!

Get tips in your inbox

Join the Quick Base Junkie Community email list!

Why you should be adding color to your reports in Quickbase

adding color formulas how to intermediate reports May 23, 2018

Subscribe on YouTube

Color coding your Quickbase report rows allows the important information to stand out. Drawing attention to critical details will save time and ignite action. Learn how to add conditional color coding to your Quickbase reports.

Make any information you want 'pop' on your table report.

  • Need to see active employees at a glance?
  • Want to highlight a task past due?
  • Desire to make out-of-stock items more obvious?
 

In this short tutorial, I walk you through three things you need to customize your awesome Quickbase reports using a formula to add color.

  1. Choose your report
  2. Identify the “trigger” field
  3. Write the color-code formula

After this quick tutorial, you’ll be well on your way to creating colorful and action-generating reports!

FORMULA FROM THE VIDEO:

Case([Employment Status],"Active","yellow","")

Formula example for multiple colors:

Case([Employment Status],
"Active","yellow",
"Terminated", "red",
"On Leave","orange",
"Not Started","blue","")

 

 

 

 

Feeling like a Junkie?  Subscribe Now!