Results 1 to 8 of 8

Compiling a checkbox form to a spreadsheet

Threaded View

  1. #1
    Registered User
    Join Date
    04-15-2013
    Location
    America
    MS-Off Ver
    Excel 2003
    Posts
    13

    Compiling a checkbox form to a spreadsheet

    Hey so I have a client that wanted me to create a form that has four options for each question for example
    1.) Morning is when I feel best
    A little of the time
    Some of the time
    Good part of the time
    Most of the time
    Each answer is supposed to have a number correlated with it i.e:
    A little of the time = 1
    Some of the time = 2
    Good part of the time = 3
    Most of the time = 4
    These numbers are supposed to be added up and calculated to have a total number. How do I make it so that each response checked is added up when the response is marked? I know the form needs to be connected to a spreadsheet, which it is, but every time I fill out the form, the responses added to the spreadsheet are the same responses that I placed in the form. I want to correspond these answers to numbers that can be added up in a spreadsheet.
    Any help on this subject would be awesome!!!
    Last edited by dzm; 04-18-2013 at 01:00 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1