Getting comprehensive control of your papers at any moment is vital to ease your day-to-day duties and improve your productivity. Achieve any goal with DocHub tools for document management and convenient PDF file editing. Gain access, modify and save and integrate your workflows with other secure cloud storage services.
DocHub gives you lossless editing, the chance to use any format, and safely eSign papers without having searching for a third-party eSignature option. Get the most of your document managing solutions in one place. Consider all DocHub features today with your free account.
today Im going to show you how to use the information youve gathered in a spreadsheet from a Google Form and separate it out automatically based on respondents answers to questions so this is a two-step process and the first step in that process is to create an import range formula on a second sheet that actually takes all of the information from your form responses and moves it over here this seems like an unnecessary step but its actually really important because the query we want to run cannot be run from the former spot sheet it has to be run from this second sheet all right the first thing you need to do let me go ahead and clear all the this data so that we can start fresh the first thing that you want to do is you want to enter in an import range formula here so Im going to go ahead and I have it here but its missing something so notice theres an n/a theres an error I need to get the URL from this first page so lets go ahead and get the shareable URL and were going to