Report Summaries - RAG Status Summary - Functionality Request

A major limitation I am currently finding with Smartsheet is the ability to be able to pull RAG status summaries into Report Summaries for charts and consolidated reporting across multiple projects.

For example - 10 project plans with 5 business units where I need to track % complete and RAG Status (which is based on performance vs plan at today's date). Report summaries allow me to view consolidated % complete by business across the 10 projects, but do not include the functionality to roll up summaries of the RAG status (e.g. a simple average).

Can this be built into Report Summaries please? I'm sure many other customers would find this useful.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!