Google Forms - Form Ranger - Auto Generating Checkbox Options based on user 'other' form inputs

[@charlespouliot7322]

Super useful. I've been trying to find a real dynamic addon, and this is great! The additional tips are fantastic! Again, thank you!

[@MrMattperreault]

Glad it helped!

[@SujayKantiPaul]

This is really useful and helpful. I can't thank you enough. Best wishes for you!

[@MrMattperreault]

Glad it helped you!

[@Satisfyingly99good]

Great work ..
But how can I deal with the problem of having too many cells to be used in the split function? 2:37

[@walternhabanga]

Hi. Is it possible to adjust to have the items separated in multiple rows? From each entry

[@MrMattperreault]

You can use the split formula or if you want only specific items in each column you could use the query formula

[@Satisfyingly99good]

Can you show us how to be done please? ​@@MrMattperreault

[@paolosorgente7097]

Hello! I'm glad you find the videos helpful. Before starting a job, I need some advice. I need to create a form for a healthcare company where we handle hundreds of calls per day. I tried using Google Forms with multiple sections, but the Google servers couldn't handle the workload. When I shared the form and Google Sheet, the scripts couldn't process properly. Do you have any advice regarding this?

[@neroetal]

is it still working

[@MrMattperreault]

Yes indeed

[@lkamons2]

Nice video!

[@manishbhattt]

=SUMPRODUCT((ISNUMBER(FIND("Cat",B:B))) - This works like a charm

[@mara_cleia3959]

You just saved me from hours of work - thank you so much!

[@manishbhattt]

@@mara_cleia3959 glad that it helped 🤗

[@yesimyagcisilahtar7731]

This is really useful, thank you so much!
Is there a way to have an initial list of options and then dynamically add new user added items to the response options?
This would help me A LOT!

[@MrMattperreault]

Yes for sure, fill out the form a few times yourself to get the first few options.

[@ozzyrefandi]

Nice

[@deepaksudhakar1]

Hi Matt, good video. FLATTEN was a nice touch.
Have you tried SORT(UNIQUE(), to get data in Ascending Order and remove an extra step.

[@MrMattperreault]

Great tip! Thanks

[@TheBarliesucks]

Great tutorial!

[@MrMattperreault]

Thanks glad it helped!