How to incorporate sorting in calculated column with background and text color formatting to use as a Grouping field

Question

Here is the calculated formula for the field:

=IF([AU-R CIR]="7. ERROR","<div style="""&"text-align:center; color: red; background: #ffffff"&""">7. ERROR</div>",IF([AU-R CIR]="6. Incomplete","<div style="""&"text-align:center; color: blue; background: #ffffff"&""">6. Incomplete</div>",IF([AU-R CIR]="5. High","<div style="""&"text-align:center; color: white; background: #c00000"&""">5. High</div>",IF([AU-R CIR]="4. Moderate-High","<div style="""&"text-align:center; color: white; background: #ed7d31"&""">4. Moderate-High</div>",IF([AU-R CIR]="3. Moderate","<div style="""&"text-align:center; color: white; background: #ffc000"&""">3. Moderate</div>",IF([AU-R CIR]="2. Low-Moderate","<div style="""&"text-align:center; color: white; background: #92d050"&""">2. Low-Moderate</div>",IF([AU-R CIR]="1. Low","<div style="""&"text-align:center; color: white; background: #00b050"&""">1. Low</div>")))))))

I want to use it as a grouping field but the built in ordering for grouping fields does not order based on the [AU-R CIR] field values.

Can the calculation formula be adjusted to accommodate the ordering?

Answer 1

Figured out how to update formula and the following works!

=IF([AU-R CIR]="ERROR","<div style="""&"font-size:1pt; color: white"&""">7"&"<div style="""&"text-align:center; color: red; background: #ffffff"&""">ERROR",IF([AU-R CIR]="Incomplete","<div style="""&"font-size:1pt; color: white"&""">6"&"<div style="""&"text-align:center; color: blue; background: #ffffff"&""">Incomplete",IF([AU-R CIR]="High","<div style="""&"font-size:1pt; color: white"&""">5"&"<div style="""&"text-align:center; color: white; background: #c00000"&""">High",IF([AU-R CIR]="Moderate-High","<div style="""&"font-size:1pt; color: white"&""">4"&"<div style="""&"text-align:center; color: white; background: #ed7d31"&""">Moderate-High",IF([AU-R CIR]="Moderate","<div style="""&"font-size:1pt; color: white"&""">3"&"<div style="""&"text-align:center; color: white; background: #ffc000"&""">Moderate",IF([AU-R CIR]="Low-Moderate","<div style="""&"font-size:1pt; color: white"&""">2"&"<div style="""&"text-align:center; color: white; background: #92d050"&""">Low-Moderate",IF([AU-R CIR]="Low","<div style="""&"font-size:1pt; color: white"&""">1"&"<div style="""&"text-align:center; color: white; background: #00b050"&""">Low")))))))