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
9 ай бұрын
Glad it helped!
@SujayKantiPaul
11 ай бұрын
This is really useful and helpful. I can't thank you enough. Best wishes for you!
@MrMattperreault
9 ай бұрын
Glad it helped you!
@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 🤗
@mohammedhamed3440
8 ай бұрын
Great work .. But how can I deal with the problem of having too many cells to be used in the split function? <a href="#" class="seekto" data-time="157">2:37</a>
@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?
@walternhabanga
9 ай бұрын
Hi. Is it possible to adjust to have the items separated in multiple rows? From each entry
@MrMattperreault
9 ай бұрын
You can use the split formula or if you want only specific items in each column you could use the query formula
@mohammedhamed3440
8 ай бұрын
Can you show us how to be done please? @@MrMattperreault
@yesimyagcisilahtar7731
2 жыл бұрын
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
9 ай бұрын
Yes for sure, fill out the form a few times yourself to get the first few options.
@TheBarliesucks
2 жыл бұрын
Great tutorial!
@MrMattperreault
9 ай бұрын
Thanks glad it helped!
@neroetal
Жыл бұрын
is it still working
@MrMattperreault
9 ай бұрын
Yes indeed
@lkamons2
Жыл бұрын
Nice video!
@ozzyrefandi
Жыл бұрын
Nice
@deepaksudhakar1
2 жыл бұрын
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.
Пікірлер: 22