Adding lists of columns to matrices | Community
Skip to main content
Answered

Adding lists of columns to matrices


Iโ€™m creating peer reviews where peers need to accredit each others skills. To do this I want to use matrices that look something like this:

Who excelled in the following skills:

                Bob        Eva        Henry       Jim

Skill 1        0             0              0             0

Skill 2        0             0              0             0

Skill 3        0             0              0             0

 

Now to do this once with a few names and columns is not really a problem. But since I need to do this with quite a large list of skills (~100). I want to divide them into categories and use multiple matrices to cover all of them. The problem Iโ€™m having is that for each matrix I need to fill in the same list of names by hand. Which becomes really annoying very fast. My question is: Is there a way to copy past a list of names into the columns so that I donโ€™t need to do this by hand.

Thanks in advance! 

Best answer by john.desborough

@DorianFP @Liz - there is not much in the way of being able to speed it up BUT if your names donโ€™t change (that much), create the first matrix question and then duplicate it .. you still have to change the other โ€˜headingsโ€™ but at least the static ones woud remain

it would be nice to be able to copy a list ie like for a dropdown question, and paste the list into the matrix row headings and have it create a row for each line in the copied file.. but it doesnโ€™t do that today.. 

 

des

View original

2 replies

Liz
Exโ€“Typefomer
Forum|alt.badge.img+5
  • Tech Community Advocate
  • 15035 replies
  • June 30, 2022

Hi @DorianFP Thanks for stopping by! We donโ€™t have a copy/paste option for matrixes, but @john.desborough is a matrix pro and might have some workarounds for you!


john.desborough
Forum|alt.badge.img+6
  • Certified Partner & Champion
  • 5428 replies
  • Answer
  • June 30, 2022

@DorianFP @Liz - there is not much in the way of being able to speed it up BUT if your names donโ€™t change (that much), create the first matrix question and then duplicate it .. you still have to change the other โ€˜headingsโ€™ but at least the static ones woud remain

it would be nice to be able to copy a list ie like for a dropdown question, and paste the list into the matrix row headings and have it create a row for each line in the copied file.. but it doesnโ€™t do that today.. 

 

des


Reply