Getting comprehensive power over your documents at any moment is crucial to ease your day-to-day duties and increase your efficiency. Accomplish any goal with DocHub tools for papers management and convenient PDF file editing. Gain access, adjust and save and incorporate your workflows with other protected cloud storage.
DocHub offers you lossless editing, the opportunity to work with any formatting, and safely eSign papers without the need of searching for a third-party eSignature software. Maximum benefit of your document managing solutions in one place. Check out all DocHub capabilities today with the 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