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.
Help Article Resources
Check out the Formula Handbook template!