Okay SharePoint/Excel 2010 drop down box list troubleshooting and fix steps RRS feed

  • Question

  • I am not sure if I am using the correct terms so bear with me

    I have 10 different excel files that list the following fields (I can combine the files)

    Department, Issue, User Corrective Action, Steps and Root cause I am trying to merge them into a select box on SharePoint using Excel as the data source  or a Excel form this is for our front line helpdesk to do some initional trouble shooting

    the Logic should be like this.


    User Selects Department BI in the next Box/Field/Dropdown list only Issues that could be related to BI are shown user selects one of those issues and on the next box/field/dropdown list only fixes for that select issue we are calling it a triage list.

    To make this short and sweet HELP

    Monday, April 16, 2012 11:09 PM