Columns display incorrectly when more than 6 items are selected in a check box

[#1]

Hi There

I am stuck here with this seemingly simple problem but have tried loads of different things over the last 2 days with no luck and cannot think what else to try.

My problem is that when I select more than 6 items in my 'Display Column' check box, it displays the wrong columns

First 6 items selected (can be any 6) - all ok

When I select the seventh column (any column) it displays the wrong columns

FYI I have changes the number of Max Values in Current selections to 50

Any ideas please?

Best Regards, Steve

[#2]

I have noticed that when I get to selecting a seventh column it now displays the inverse (non selected) columns. Any suggestions please.

[kji]

The defenition looks like:

str GetFieldSelections (field_name [, value_sep [, max_values=6]])

so try with GetFieldSelections(Columns, ',', N), where N is the number of maximum columns.

[#4 · Accepted solution]

Hi Johan

Thank you very much. You helped a lot. For anyone else out there my finished code per column was:

=if(substringcount(GetFieldSelections(Columns, '', 30), 'P.H. Code')>0, true(),false())

Thank you.

Steve