Forum Discussion

Qrew Trainee

8 years ago

Red Amber Green Status based on other fields - Please help

Hi, I have a table called Risk I want to create 3 Fields - Risk Impact, Risk Probability, and RAG Status as shown below: What should be the field type for Impact and Probability. I...

QuickBaseCoachD

Qrew Captain

8 years ago

There is some help here on how to create new fields to display with background shading. You need to make new fields, you cannot just do Conditional formatting like in Excel. So typically you a a field for data entry and another field for use in display mode on a report or form.

http://help.quickbase.com/user-assistance/Default.html?_ga=2.11633908.1761511295.1509972295-12185085...

_anomDiebolt_

Qrew Elite

8 years ago

You can also use no quotes if there are no spaces in the attribute value:

"<div style=background-color:pink;>"& [Priority] & "</div>

Forum Discussion

Red Amber Green Status based on other fields - Please help

Related Content

Formula needed to pull out most recent status of a logged multiple choice field

Snapshot Fields

Status Field Based on Contract Status

Find and Replace Field Values

Merging 2 Fields into a Formula-Text Field for Reporting Purposes