Hello,
I need help developing formulae for my matrix table.
In attached file you will find sheet "open risks" and "closed risks", look for columns "Impact" and "probability". In these two sheets rows will always be adding additionally, when we need to open new "risk" or new row.
I want to show the risk_id (column A in open and closed risks sheet) in the "matrix" sheet in the right bracket, so depending of the value that each row has in columns impact and probability. Only difference is, if the row is in "close sheet" then have risk_id wirtten with (closed) at the end, for example R-0029 (closed).
The values in matrix are just for presentation for you to get the idea. If the bracket is full, do not add it to the list, so don't worry about that.
Any help will be greatly appriciated!
Thank you.
I need help developing formulae for my matrix table.
In attached file you will find sheet "open risks" and "closed risks", look for columns "Impact" and "probability". In these two sheets rows will always be adding additionally, when we need to open new "risk" or new row.
I want to show the risk_id (column A in open and closed risks sheet) in the "matrix" sheet in the right bracket, so depending of the value that each row has in columns impact and probability. Only difference is, if the row is in "close sheet" then have risk_id wirtten with (closed) at the end, for example R-0029 (closed).
The values in matrix are just for presentation for you to get the idea. If the bracket is full, do not add it to the list, so don't worry about that.
Any help will be greatly appriciated!
Thank you.