I have (somehow) managed to create one column which successfully links to the Resource Sheet. When using the drop down, it brings up all of the names in the resource sheet, and allows you to choose multiple names. The column is then populated with all of the names selected. I have also renamed this particular column for one of our roles (Approver)
I would like to add three more columns (for three additional roles: Action Owner, SME and Developer(s) ) which behave EXACTLY the same way, but cannot determine how to do this.
A simple "paste and copy" of the Approver column, does create another column, but, as expected, the values are exactly the same. If you change a cell in the "Approver" column, the cell in the other column changes as well. This is not what i need.
The four columns should all be able to choose values from the same resource sheet, allow multiple names per cell, and, most importantly be totally independent.
- For example
Approver: John Action Owner: Mary, Sue, Robert SME: Jason, Todd Developers: Crystal, Scott, Meredith
How (exactly - step by step), do I:
- create each of these three new additional columns,
- map them to the same Resource Sheet
- have the capability of choosing multiple values for a cell
- have all four columns work entirely independent of each other