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, 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, select Response Projects and click Create New.
- Compete the project meta data.
- Click Upload Document, and browse and upload your document. Document will be auto-configured.
- Select the Answer column and map it with Answer from the right menu options.
- The Answer Configuration pop-up appears. Change the Answer Header to Response.
- Select Multi-Column Dropdown as Answer Type.
- Add the required answer options. You can add multiple options by selecting Add Answer Options and click Save.
- Click Save and then Import.