I want to remove the subjectivity in reporting on project domains. The aim is to use a formula to determine the 'summary rating' of a domain eg risk. This will be based on the content of the risk log (sheet).
Community help is requested on the formula.
The table below maps the thinking to develop the formula. I think it will start with 'IF"; that all I have 😥. It needs to account for all of the criteria and return a red, amber of green and a grey if all four columns are blank. Any help appreciated. Word of warning - if you solve it there are more of the same for issues, schedule, change readiness and overall!
Help Article Resources
Check out the Formula Handbook template!