Wednesday, June 13, 2012 5:09 PM
What can you do with a Choice (multi-select) Column once you have it set up.
I have a list
Column A = Report Name
Column B = Group Name (Choice multi-Select) More than one Group can use a report
Column C = Yes or No (Does the Group use the report or not)
I would like to generate a view that is grouped by Column B (Group Name) but that column is not visable when I want to reference it in either a calculated column or a lookup column.
Is there any way to select on a Choice multi-select column, if not what is the point?
Thursday, June 14, 2012 3:41 AM
This cannot be achieved OOTB and hence you have to go for a custom solution. You can check the following threads which discusses the similar issue -
Thursday, June 14, 2012 6:44 AMModerator
For this issue, you cannot achieve this through user interface, we suggest you to custom Data View through SharePoint Designer. Below is the steps I have tested in my local server.
- Create a list listA, add three columns, columnA, columnB(Multi-Select) and columnC(yes or no).
- In SharePoint Designer 2007, open the site which has the listA, create a new aspx page and then insert a Data View on it, locate the Data Source Library (listA), drag the Title, columnA, columnB and columnC to be displayed on it.
- Click on Data View Properties, in the Editing tab window check the two options, show edit item links and show insert item links(you can edit and insert item through data view).
- (configure sort and group)Right-click the Data View, and then click sort and group , in the variable fields, click Add Sort Expression, select columnB. Under Group Properties, select the Show group header and select Expand group by default. Then click Advanced Grouping, select the Show column names per group .
Please check it, if there is any problem, please feel free to let me know.
TechNet Community Support