Discover how to automatically move Google Forms data in a Google Sheet to separate tabs with this tutorial from Top Contributor.
694 plus ones
Shared publicly•View activity
View 143 previous comments
- Hi Ted! You're so helpful wowow. Is there a way to automatically move all responses from a specific section of a form into a separate tab in a spreadsheet (or from the main responses spreadsheet to a different tab). I use my spreadsheet for work on an ongoing basis (not for one specific project). One of the sections of the form is "follow-up" where I enter future tasks to be completed. However, I only have follow up for certain entries. I would like a tab in my spreadsheet that consists only of form entries with ANYTHING written in the follow up section (otherwise will be left blank). Is there any way to do this?
Thank you so so much!14w
- Trying to set this up on my spreadsheet and it keeps giving me an error.
parse error . very frustrating8w
- I like this4w
- I'm using not werkink spreadsheet4w
- How do I create a different tab each time there is a different time stamp? I want to automatically sort the responses by WHEN they were submitted. I am creating an exit ticket for students and I want to check their Daily responses. I am not very literate in sheets so I have a hard time with copying the formulas. Thanks!4w
Did you ever solve your issue about selecting A or B depending on what the contents were? I am having the same issue now and would love any help.
Add a comment...