Is there a formula to calculate the overall state of a specific group of projects in a metadata?

Hi Smartsheet Community,

I am trying to calculate the total number of green, yellow and red projects I have on a sheet based on different project groupings. My goal is to be able to have a chart in the dashboard that would report on the overall state of a group of projects based on their location or strategic initiative.

Any suggestions on what this formula would look like would be greatly appreciated.

Thank you!

Melisa Ozdeniz



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!