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.



  • Genevieve P.
    Genevieve P. Employee Admin
    edited 07/06/23

    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:

    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?)



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!