Question Matrix column disperses between rows

[morgank]

Hi,

I’ve had success before building a question matrix using XLS Form that has multiple columns for integer input, then totals the values in the columns at the bottom.

I tried to create a similar form for a slightly different purpose, the calculations work fine, but the ‘attendees’ column is dispersed as long rows between the other rows, rather than appearing as a column (See screenshot below). I’ve also added a screenshot of the XLS form below in comments.

Does anyone have any idea how I could fix this?

Thanks!

[morgank]

Here is the XLS Form

[phanlinh1987]

@morgank

the calculations work fine, but the ‘attendees’ column is dispersed as long rows between the other rows, rather than appearing as a column (See screenshot below). I’ve also added a screenshot of the XLS form below in commen

It should be W6 (6 columns) for all in “appearance” intead of W5.

[morgank]

Thankyou so much! It’s working perfectly now!

[phanlinh1987]

Glad to hear that

[Kal_Lam]

@phanlinh1987, expecting similar support to the community in the upcoming days!