![]() Note: Do remember that changing the sequence / number of questions in the form will affect everything! If doing this, be careful, and always make sure to check that the filters are using the correct column sequences.Once the sheet+form setup is working, go ahead and customize the options in the google form, names of your credit cards, your spending categories, etc.This should populate the sheet as expected.(you can also click on the preview button and then fill it there) Open your form and fill out your first expense. ![]() We basically asked the back-end sheets to switch to the data in res (instead of the older responses)Īt this point, the dashboard and the rest of the sheets will look empty, so go ahead and fill out your form.Head over to the sheet called _responses and in the first cell A1, change the formula to =ARRAYFORMULA(res!A:I).Rename this sheet to something simpler like res (I'm avoiding using responses because it's already there).This is the one we'll link to the back-end. Try Using Our Weekly Budget Worksheets And Monthly Expense Tracker Templates In Your Quest To Make Your Budget And Expense Management On Your Income More Organized. If you look at your spreadsheet closely, it now has a new sheet called Form Responses. Expense Tracking Can Be Very Tedious That Is Why Is Making It Easier For You. Here, choose your copy of the Google spreadsheet in the Drive.Open your copy of the Form, head to the Responses tab, click on the green Create Spreadsheet button.It's time to link your form to the spreadsheet. The Form link should directly suggest creating a copy once logged in.Note: This option is only accessible when you're logged into your Drive account.Make sure you're logged into your Google DriveĬreate copies of the sheet and the form.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |