Overall RAG Automation: Risk Register

Kaleb

Smartsheet Community:

Has Anyone Automated RAG for The Overall Risk Register? For Example, The Risk Register has 6 Risk, 3 are Red, 2 Yellow, 1 Green Resulting in an Overall RAG Rating Yellow.

Thanks

Genevieve P.

Hi @Kaleb

The average at the end will depend on the weight you'd like to give each of your status symbols. There are a few other threads here in the Community that show how other members have automated this:

• Using symbols in cells and then averaging those cells
• Averaging RGB balls
• Schedule Health | Average RGYB symbols

I personally like the idea in the first thread where they used a Helper Column to define a numerical weight based on the status colour for that row, then averaged that column to find what average colour should display in the symbol column.

Let us know if you need help after reviewing those other posts! If so, it would be helpful to know exactly when you want each overall status to appear (e.g. if there are 5 Green and 1 Yellow, is that Green? What about 5 Green and 1 Red?)

Cheers,

Genevieve