Skip to main content
Question

Red Amber Green Status based on other fields - Please help

  • November 7, 2017
  • 0 replies
  • 60 views
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. Ideally I would like it to be numeric. But if it is numeric it should also display the description for each number.

I guess I can also put it as text and have options such as '1 - Extremely Remote'. In that case what will be the formula for RAG status?

Thanks
      This topic has been closed for replies.

      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
      • Registered
      • November 7, 2017
      I would use text multiple choice fields for [Risk Impact] and [Risk Probability] both talking values "1", "2", "3" or "4". Then [RAG Status] field would be a text formula field taking values "G", "R" or "A" with the following formula:
      If([Risk Impact] = "1" and ([Risk Probability] = "1" or [Risk Probability] = "2" or [Risk Probability] = "3")
         or
         [Risk Probability] = "1" and ([Risk Impact] = "2" or [Risk Impact] = "3"),
         "G",
         If([Risk Impact] = "3" and [Risk Probability] = "4")
            or
            [Risk Impact] = "4" and ([Risk Probability] = "3" or [Risk Probability] = "4"),
            "R"
         ),
         "A"
      )

      To the extent you also need text labels for any of these fields you can use a Case() function to generate them. For example:
      Case([Risk Impact],
        "1", "Insignifigant"
        "2", "Signifigant",
        "3", "Critical",
        "4", "Catastrophic"
      )
      Terms & ConditionsAccessibility statement