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
'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/
3)
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
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
No comments:
Post a Comment