Overview
A multi-column drop down is when there are multiple columns designated for each response. The issuer oftentimes wants you to place an "X" in the column indicating your response from the header above.
Configuring Multi-Column Drop-Downs in Excel
In the Excel file outside the solution
- Identify your sections whether within the worksheet cells or the name of the worksheet itself.
- Identify your questions.
- Identify the columns containing your different answers at take note of their numbers (e.g. columns E,F & G).
In Responsive; the solution itself
- Select Response Projects.
- Select Create New.
- Compete the project meta data.
- Select Import Files.
- Select Advanced Configuration.
- Mark your sections whether within the worksheet cells or the name of the worksheet itself.
- Mark your questions.
- Select the first cell of your response, and mark it as an answer.
- Change the answer type to a multi-column drop down.
- Select Add Options for each column you must configure.
- In the field called Excel Column Name place the value for the first column (e.g. E)
- In the field called Value in File input the value you want displayed in the column (e.g. Y or Yes).
- In the field called Value in UI input the value you want your users to select within the active project (e.g. YES or Meets Requirements).
- Select Add.
- Select Save.