Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Jun 17, 2013
user Atio (http://productforums.google.com/forum/?zx=qbs7kko366y6#!category-topic/docs/spreadsheets/YosZMa7O9Fw)
String for multiple filters on spreadsheet?
I am trying to build a "report" sheet, which I could embed into a Google Site.
I have a spreadsheet which contains 18 columns of data (A - R). It's a sales/fulfillment sheet, showing things like Product ID, Sales amount, Sales Rep Name, Process Date, and Ship Date (and quite a bit more.)
(to hopefully make things clear, let's call the full 18-column sheet "Source" and the sheet I'm trying to generate "Report"):
Here's what I'm trying to do:
First, on the "Report" sheet, I am calling only certain columns from the "Source"....using this string:
This part works OK.
I also want to be able to see a filtered view of the "Report" sheet, filtering TWICE, using values from two columns. From the 'raw' version of the "Report" sheet, I would like to first filter by "SalesRepName" (Column F on "Source" and Column E on "Report) and then I would like to filter that list further, showing only BLANK entries on "DateShipped" (Column N on "Source" and Column J on "Report").