Prompt for descriptive text when user checks "Other" checkbox
Dear,
I have a survey that have checkbox questions with other option.
The responser can choose all the options plus the other option. So, when he/she choose other option a textbook will be open to write his/her own text.
My question is how to calculate the entered texts that are different than the options provided in the question.
Note: Sheet1 is the question and Sheet2 is an example of the responses.
Regards,
Screen Shot 2021-06-02 at 12.20.34 PM.png
Last edited by Fmoh; 06-03-2021 at 02:04 AM.
Welcome to the forum
Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
Please update your profile with your Excel version (2013, 2016,2019 ...)
Last edited by JohnTopley; 06-02-2021 at 09:59 AM.
Thank you,
I've updated the post.
Thank you for the file.
Question: how are you planning to summarise the responses as they are collated as per Sheet2 i.e all in one cell? There is no easy way without multiple "searches" to identify each text string.
How many questions? how many possible responses? How many respondents?
Last edited by JohnTopley; 06-03-2021 at 03:48 AM.
All the chosen options will be in one cell.
I used =COUNTIF(range,"*"&A2&"*") to count all the school answers. So, the problem is how to count the entered option by the user (when he/she chose other option).
The number of responses is about 300.
As an example of finding the "Others"
In Sheet2
n B2
=TRIM(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2,Sheet1!$A$2,""),Sheet1!$A$3,""),Sheet1!$A$4,""),";",""))
There are 2 "separators" (semi-colon and comma) so this inconsistency does make it more difficult.
If you need to identify individual "Others" then further "Substitution"-like formula will be required BUT these are unknown until survey is completed,
I don't know how the data is entered but I would avoid putting all responses to a given question in a single cell to avoid the difficulties highlighted above.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks