Overall RAG Automation: Risk Register
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
Answers
-
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
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!