Filtering Data from ImportRange...
I have created a tabulated output of the data based on "Responses" spreadsheet. I'd like to enable user to view the filtered data based on the input in B1 of spreadsheet "Dashboard". How do I go about getting only the relevant data to be imported to C3 of the latter. So also for the remaining cells in D8:I12.
"Responses" : https://docs.google.com/spreadsheet/ccc?key=0Aqc3Vh83ndmwdHJYVzdEN2JBdTVOaWFteF9MTnA5TkE#gid=0
Formula used: =query(ImportRange("0Aqc3Vh83ndmwdHJYVzdEN2JBdTVOaWFteF9MTnA5TkE","Responses!A2:A6"),"select* where Col1=date '"&text(B1,"yyyy-MM-dd")&"' ",9)
Instead of getting filtered data, all cell contents are imported to the designated cell. Your advise will be much appreciated. Many thanks!
|a) tell me what you are trying to accomplish|
|b) in which cell?|
|of which sheet?|
|c) show me your expected result|
|along with needed logic/explanation|
|and then let us take it from there.|
|Make It A Great One|
|Cloud Computing -- Google Docs Way|
Dashboard!C3: to populate relevant data under column A when Responses!I=Dashboard!B1
Some community members might have badges that indicate their identity or level of participation in a community.
Member levels indicate a user's level of participation in a forum. The greater the participation, the higher the level. Everyone starts at level 1 and can rise to level 10. These activities can increase your level in a forum:
- Post an answer.
- Having your answer selected as the best answer.
- Having your post rated as helpful.
- Vote up a post.
- Correctly mark a topic or post as abuse.
Having a post marked and removed as abuse will slow a user's advance in levels.
View profile in forum?
To view this member's profile, you need to leave the current Help page.
Report abuse in forum?
This comment originated in the Google Product Forum. To report abuse, you need to leave the current Help page.
Reply in forum?
This comment originated in the Google Product Forum. To reply, you need to leave the current Help page.