I have a RASCI TAble that Teylyn has helped build out that I'm ready to take to the "next level". If you look at the attached file, you will find a table of data that reprsents;
1.) A priority based on Critical Path
2.) A Description of Processes or Activities
3.) A Role Name
4.) A Person's Name
5.) and A RASCI Code (Responsible, Accountable, Supportive, Consulted, Informed)
This data is inputted into a table and could include up to 100 entries.
The Table/Graphic on the right shows Processes on the Y Axis and Roles on the X Axis (on top)
Presently (what works):
When you put in a RASCI Code, it goes into the appropriate cell and conditional formatting shows where there may be gaps (in Red).
When you change the priorities, the order on the data reorders (try changing a number in column A and you will see the critical path change.
What I need help with:
1.) You should be able to enter multiple copies of the same processes but it should only show up once in column H (automatically)
2.) For each different role, a position should show up on the horizontal axis or set of cells (automatically)
3.) The correct code should populate the correct cell. Based on the RASCI Code input.
4.) There should be a reset button that allows you to start over.
Any help with this would be most appreciated and a real asset to anyone using RASCI with clients.
There will be a follow on question about how to change the priority in the table but that will be the next version.