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
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 210 Industry Talk
- 441 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 300 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!