<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=ISO-8859-1">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Hi Firefox dev,<br>
<br>
If you're like me, you're thinking, hey, this spreadsheet tracking
all this stuff is neat and all but WHY CAN'T I FILTER/USE IT!?<br>
<br>
So then you copied it. And it got out of date. And you were even
more annoyed than before.<br>
<br>
Now, in my case, I then used my favourite search engine and found
out that Google Docs has a neat "importrange" function which you can
use. So here's my sub-2-minute, 5-step plan to have a version of
this spreadsheet that I can easily adjust myself (to a degree,
sadly, more at the end of the steps) and which I hope is useful for
other people on this list to easily track their iteration bugs, and
find new ones:<br>
<br>
1. Create a new spreadsheet in Google Docs<br>
2. Select the first cell (or really any cell, I guess)<br>
3. Enter:<br>
<br>
IMPORTRANGE(<a class="moz-txt-link-rfc2396E" href="https://docs.google.com/spreadsheets/d/10sr6YhDNmO4oimlNtxDZ5fe6IaQKmZ7gqT-ZWqAygrI">"https://docs.google.com/spreadsheets/d/10sr6YhDNmO4oimlNtxDZ5fe6IaQKmZ7gqT-ZWqAygrI"</a>,
"IT-32.3 Data!A:L")<br>
<br>
(Note: "IT-32.3 Data" is the name of the sheet - next week brings
"IT-33.1 Data", and so forth; you'll need to update this yourself
every 2 weeks, but that should be easy to do)<br>
<br>
4. Behold what all that data looks like unformatted. Now, YMMV in
what you want to do with this sheet, but in my case:<br>
a) I added conditional formatting (Format > Conditional
formatting...) for "Verified" in column H (use range "H:H" because
it doesn't like just "H") to make it nice and green<br>
b) I hid columns D (region), F (Work Type), I (QA Status, ie qa+/-)
because they're not relevant for me<br>
c) I adjusted some column widths<br>
d) I turned on filtering: Data > Filter so I can easily filter
for just my bugs (what I use by default) or blank bugs (when I need
to look for new work), and filter out engineering/pm/ux bugs, etc.<br>
<br>
5. Limitations:<br>
a) no links to bugs because the formatting is all gone. To fix this,
add a column at the beginning (right click column A, insert 1
before) and insert this in the first row:<br>
<br>
=REGEXREPLACE(B2, "[Bb]ug (\d+).*",
<a class="moz-txt-link-rfc2396E" href="https://bugzilla.mozilla.org/show_bug.cgi?id=$1">"https://bugzilla.mozilla.org/show_bug.cgi?id=$1"</a>)<br>
<br>
(I don't know if this can be done without a separate column)<br>
<br>
b) no sorting. Because the data is imported and updated from the
original spreadsheet, sorting data using the menus will seem to work
initially... and then fail miserably. This is annoying, but
fortunately you can often find what you want by just using the
filters or google docs' find function instead.<br>
<bdo dir="ltr"><span class="formula-content"><span dir="auto"
class=" default-formula-text-color"><br>
<br>
</span></span></bdo>Hope this is of help to other folks working
with these sheets :-)<br>
<br>
~ Gijs<br>
</body>
</html>