AnsweredAssumed Answered

List and Middle Values for checkbox results

Question asked by benbear on Oct 24, 2018
Latest reply on Oct 25, 2018 by benbear

I am hoping someone might be able to help. I am using the list and MiddleValues functions to return selected values in a checkbox set of about 20 items of which only 12 can be selected

what i am trying to do is return the results into 3 columns of 4 purely for space purposes on a layout.

I tried MiddleValues (List ( Job Type )  ; 1 ; 4 ) as 1 calculated field then as the 2nd calculated field MiddleValues (List ( Job Type )  ; 5 ; 8 ) and third calculated field as MiddleValues (List ( Job Type )  ; 9 ; 12 ) however this returns the first 4, then next 6 and then 2 for the final calculation. I am not sure if i am using this correctly or if there is another method to achieve what i want.

Thanks in Advance

Outcomes