Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Question
Monday, December 12, 2011 9:13 PM
Hello All,
I am new to Sharepoint and have a question the hopefully is easy to answer.
I have been charged with converting a spreadsheet to a Sharepoint site. This spreadsheet keeps track of the software available at different sites in our SCCM deployment. This spreadsheet has several rows displaying where the network segment is similar to the table below.
| State | |||
| City 1 | City 2 | ||
| Office 1 | Office 2 | Office 3 | Office 4 |
I would like to mimic this in Sharepoint so that I can filter based on State, City, or office. I was looking at using lists but I can't figure out how to combine them all into one list so that I can easily filter.
Any help would be appreciated.
All replies (3)
Wednesday, December 14, 2011 3:39 PM âś…Answered
I see. Are there set software packages that each office has? Like Office1 has Sales/Dev with standard Sales and Dev Software packages. SharePoint OOTB doesn't have the ability to create Nested Lists. What you can try and look into using is multiple lists that are interconnected through the use of LookUp Columns.
Other option is through code. I found a post by Rashmi Bhimani on Nested List Display achieved through SP Designer. http://www.codeproject.com/KB/XML/NestedListSP.aspx.
Hope some of this helps you in finding a solution..
Please Mark Answered if my reply solves your problem. Thanks!
Monday, December 12, 2011 9:27 PM
Hi,
How about a list containing multiple columns - one for State, another for City, another for Office, etc? This way, a list view can be created that sorts based on any or all of the columns that you've created.
Please Mark Answered if my reply solves your problem. Thanks!
Tuesday, December 13, 2011 1:05 PM
Thanks for the reply.
The problem is that we have 45+ offices and some software, such as Office and Adobe products, is available at all of the sites. This would create thousands of rows that aren't necessarily required if I can figure out a way to have all offices be columns. I know it is the same amount of data to go through but it would be a lot easier to put new software into the list.