Thursday, April 18, 2013

yogi_Compute Stats From Data In Multiple Tabs


                                          Google Spreadsheet   Post  #1143
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Apr 19, 2013
user Kathleen Jacobs :(http://productforums.google.com/forum/?zx=xgt56973o6ki#!mydiscussions/docs/Au6yTTF0V-0)
Is there a way to search all Tabs?
I have a Result Tab and 10+ Tabs that all have the same Column Titles.

On the Results page, is there a way to search All tabs under that specific column title and pull that info to the results page

Example:

Tab A
Test    Result     Link
A        Fail         www.a.com

Tab M
Test    Result     Link
A        Fail         www.a.com

'etc'


Tab Result Page 
If column 'Result' in All Tabs is Fail, show the Link (This possible?)
If Column 'Result' has text, Show the Tab title   (This possible?)
---
https://docs.google.com/a/pocketgems.com/spreadsheet/ccc?key=0AuAQEcWrRho2dGk0WWZhTkdtam5sNmVsUFJNRkxzbnc#gid=0

A) Need help with the following formula's:
1) =COUNTIF('Test Cases 1'!C:C,"=Fail")
2) =filter('Test Cases 1'!D:D,'Test Cases 1'!C:C="Fail")
3) And a formula I have no idea if possible: Would like all sheets, that if it has something for 'Day 1' 'Resolution', it will list the name of the Tab

B) In Which Cell?
1) B2
2) B7
3) B22

3) Expected Result:
1) 6 (From the fails on Tabs 'Test Cases 1' and 'Test Cases 2')

Needed Logic: Currently searched Tabs that I have to include in the formula, would not want to update the formula every time I add a new tab, and will have 20+ tabs.  Need a way to gather information on multiple tabs

2) (From the fails on Tabs 'Test Cases 1' and 'Test Cases 2')

Needed Logic: Currently searched Tabs that I have to include in the formula, would not want to update the formula every time I add a new tab, and will have 20+ tabs.  Need a way to gather information on multiple tabs

3) 
Test Cases 1
Test Cases 2

Needed Logic: Would like all sheets, that if it has something for 'Day 1' 'Resolution', it will list the name of the Tab
---------------------------------------------------------------------------------------------------------------

following is a solution to the problem