Check if there are any spaces in your formula

Hi... the responses section gives a chart. Having the columns separate in google sheets or excel makes it easier to analyze on the go.

Hi! Missed replying to you! Check if you have an extra comma somewhere in the formula

Hi! Missing replying to you, I hope the formula worked for you by now :P

Yes, the same formula holds in google sheets as well.

Yes there is! I just tried it in Google Sheets and the formula is exactly the same. Instead of 1 as the output value, I used $B2&" "&$C2 for the final part of the formula because my B column was first name and my C column was last name. That way, I could easily see the names of who had signed up for each column without scrolling back to the left.

Hi! Missed replying to you! Same formula in Google Sheets

Could you be a little more specific?

You could let us know where you're getting an issue and then maybe we can help :)

Same here. I am getting 1 in every cell

Hi! You can make a bar chart with the total counts for each column. Pie charts don't work for questions with multiple select.

Hi! You could use the transpose function while pasting it in Excel (under Paste select the transpose option) but you'll need to do that for every question manually. The only other way possible is to design a macro.

@teddahrable thanks, we'll try to zoom in on the formula part in our next videos. You could also try going for full screen at a higher video resolution incase the formula seems to be blurred. For now here's the formula we've shown: =IF(ISERROR(SEARCH(C$1,$B2)),"",1)

@@kaisynlearning thank you.

Thanks Raphaël. That's a tough one. Specifically because Google Forms do not give the custom answer appended by any specific string such as "Other -" . Hence the formula to retrieve a custom answer would be complex - but possible anyway. First you'd need to check which of the given options were marked, then compare their combined lengths and the number of expected commas+spaces with the total length of the response column. If they don't match then search for the unmatched length and use the RIGHT function to obtain the custom text from the response column. Google Forms has an Apps Scripts feature which can be used to get this function working within the form itself - it will have similar logic. So you could explore that. Or you could wait and pray that Google rolls out this much-much needed feature as a simple setting. :P

@@kaisynlearning Thanks for the detailed answer! I ended up writing my own App Script for exporting the form in the format I needed. I took a while and the export isn't as fast as Google's native one but it worked for my purpose.

Hi, it's because one of the options is a part of the other (I think you mean the other way round - if the response is female friends only, then both male and female are marked as one.) In such cases you need to use an extra identifier in any one of the options - for example replace "female friends" by "female-friends" in both your data as well as your column headers.

Hi Rafael... couldn't exactly understand your query... could you send us a screenshot of your problem at [email protected]?

You can try increasing the data quality for the video

Hi Praveen! Could you clarify your question a bit?

@@kaisynlearning when a user fill a Google form and chooses multiple choices and that Data should be exact Under the same heading in the sheets or Excel

@@es_praveen5 That's what the video shows!! Do watch it completely!

docs.google.com/forms/d/e/1FAIpQLSe0vOzBP6BVh1FZl5FDCZz4gf5ZwH2BwXhCy_V57ao52SvHAw/viewform?usp=sf_link Please fill this form and thanks in advance