I would like to pull out some data from my form response sheet to a new
sheet.
Here are some data that is gathered in the form.
- Income/Expenses
- Total Amount
- Description
- Date
The data i need to gather to appear on the new sheet is "Income" for a
specific month.
But i am not sure how do i pull out just the income of the specific month.
I was trying to do it in a way that I can type in the month I want and call
out the data.
The following is the code i used but it returns #NA
=if(len(D1)=0,"Type in a month",query('Form responses 1'!A2:G,"Select *
Where B = 'Income' and E contains """&D1&""" "))
D1 is where i type in the month i want to see in the new sheet.
B is the column where it shows either Income or Expenses.
E is the date column in my Form responses sheet.
When it is just
=if(len(D1)=0,"Type in a month",query('Form responses 1'!A2:G,"Select *
Where B = 'Income' "))
it works fine. It managed to pull out all the income data. But I need to
filter by month.
Can somebody help?
--
You received this message because you are subscribed to the Google Groups
"Google Visualization API" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/google-visualization-api.
For more options, visit https://groups.google.com/d/optout.
