tag:help.lighthouseapp.com,2008-09-20:/discussions/suggestions/606-include-tags-in-the-export-fileLighthouse: Discussion 2011-04-07T05:37:57Ztag:help.lighthouseapp.com,2008-09-20:Comment/22334392010-07-20T01:48:15Z2010-07-20T01:48:15ZInclude tags in the export file<div><p>Brian -</p>
<p>Tags are part of the export file (<a href=
"http://itrgroup.lighthouseapp.com/export">http://itrgroup.lighthouseapp.com/export</a>),
but it appears somehow they were overlooked on the project level
CSV file. Thanks for pointing that out to us and we'll update for
the next deploy.</p>
<p>Thanks,<br>
Nicole</p></div>Nicoletag:help.lighthouseapp.com,2008-09-20:Comment/22334392010-09-23T15:26:05Z2010-09-23T15:26:05ZInclude tags in the export file<div><p>Nicole,</p>
<p>Do you know when this will be fixed?<br />
</p></div>Brian Koehlertag:help.lighthouseapp.com,2008-09-20:Comment/22334392010-09-23T17:03:43Z2010-09-23T17:03:43ZInclude tags in the export file<div><p>Brian -</p>
<p>I'll see what the ETA is and get back to you today.</p>
<p>Thanks,<br />
Nicole</p></div>Nicoletag:help.lighthouseapp.com,2008-09-20:Comment/22334392010-09-27T17:04:18Z2010-09-27T17:04:18ZInclude tags in the export file<div><p>Brian -</p>
<p>Tags as part of the CSV export has been deployed. Thanks for your patience!</p>
<p>Nicole</p></div>Nicoletag:help.lighthouseapp.com,2008-09-20:Comment/22334392010-09-27T18:29:16Z2010-09-27T18:29:16ZInclude tags in the export file<div><p>Nicole,</p>
<p>I tried the export, it does contain the tags, but unfortunately when there are multiple tags, I can't use it with Excel. My goal is to count how many tickets are open for each tag. I am not aware of any excel command to count if a cell "contains" a value versus equals a value.</p>
<p>I tried using spaces but that messes up the rest of the export.<br />
</p>
<p>Can you have each tag separated by a comma? This makes importing into excel easy. Even if the heading is off that is okay.</p>
<p>Thanks,</p>
<p>Brian Koehler, PMP<br />
ITR Group Inc.<br />
651-757-4525</p>
<p>-----Original Message-----
From: Nicole [mailto:<a href="mailto:tender+d1d5a33eff99008737465e5599f4ea541ac0f6859@tenderapp.com">tender+d1d5a33eff99008737465e5599f4ea541ac0f6859@tenderapp.com</a>]<br />
Sent: Monday, September 27, 2010 12:06 PM<br />
To: Brian Koehler<br />
Subject: Re: Include tags in the export file [Suggestions]</p></div>Brian Koehlertag:help.lighthouseapp.com,2008-09-20:Comment/22334392010-09-27T19:13:53Z2010-09-27T19:13:53ZInclude tags in the export file<div><p>Unfortunately the file is a CSV file, so it's already separated by<br />
commas. Also, tags can be two words with a space - e.g., "Version 2.0"<br />
- so your tag list will look like <code>ui bugs "Version 2.0" launch</code></p>
<p>For excel, have you used the 'countif' function?</p></div>Tiger Teamtag:help.lighthouseapp.com,2008-09-20:Comment/22334392010-09-27T19:14:34Z2010-09-27T19:14:34ZInclude tags in the export file<div><p><a href="http://office.microsoft.com/en-au/excel-help/countif-HP005209029.aspx">http://office.microsoft.com/en-au/excel-help/countif-HP005209029.aspx</a><br />
has some functions that look pretty much like what you want here.</p></div>Tiger Teamtag:help.lighthouseapp.com,2008-09-20:Comment/22334392010-09-27T19:43:50Z2010-09-27T19:43:50ZInclude tags in the export file<div><p>Yes I have used the count if function. I appreciate you helping with this. However, one of the limits with Excel you cannot count if there are two values in a cell. All their examples have one value in the cell. Since there are multiple tags in the export field I have a work around. I convert using comma, then delete all columns except tags. Save it, then open with spaces as a delimiter, then I get the single values in each cell.</p>
<p>Example:</p>
<p>Column A<br />
tag1<br />
tag2<br />
tag1 tag2</p>
<p>if you use the expression: countif(A1:A3,"tag1") you will only get a return of 1 not 2.<br />
I am not aware of how to use the countif command with a "contains" function.</p>
<p>Also I don't believe tags can have spaces in lighthouse, at least we don't allow them in our tagging.</p>
<p>Thanks,</p>
<p>Brian Koehler, PMP<br />
ITR Group Inc.<br />
651-757-4525</p>
<p>-----Original Message-----
From: Court3nay [mailto:<a href="mailto:tender+d1d5a33eff99008737465e5599f4ea541ac0f6859@tenderapp.com">tender+d1d5a33eff99008737465e5599f4ea541ac0f6859@tenderapp.com</a>]<br />
Sent: Monday, September 27, 2010 2:16 PM<br />
To: Brian Koehler<br />
Subject: Re: Include tags in the export file [Suggestions]</p></div>Brian Koehlertag:help.lighthouseapp.com,2008-09-20:Comment/22334392010-09-27T21:13:09Z2010-09-27T21:13:09ZInclude tags in the export file<div><p>A few options:</p>
<ul>
<li><p>you can use "Text to Columns" to split the tags column into multiple
columns without messing with the CSV file.</p></li>
<li><p>If you want to do this regularly, you could also build your tag list
with something like this:</p></li>
</ul>
<p><a href="https://spreadsheets.google.com/ccc?key=0AsxdtgWhAZ2HdC1uMmNic3ppWFpxVExzdmk5SnF5OVE&hl=en&authkey=CIjT5eEO">https://spreadsheets.google.com/ccc?key=0AsxdtgWhAZ2HdC1uMmNic3ppWF...</a></p>
<p>Basically it takes a few rows, splits the tags out, and does a count<br />
of them in your document using a simple uniqueness checker and a<br />
countif.</p>
<p>You'll probably use 'lookup' in excel instead of 'index' (they're<br />
basically equivalent). And I'd put this as Sheet 2, where Sheet 1 is<br />
your CSV export, so you can just add the sheet to the doc and it<br />
magically calculates everything. Let me know if you want me to explain<br />
anything in there.</p></div>Tiger Teamtag:help.lighthouseapp.com,2008-09-20:Comment/22334392010-09-27T21:24:55Z2010-09-27T21:24:55ZInclude tags in the export file<div><p>Courtney,</p>
<p>Thanks for the help! I am able to get what I want by highlighting the tags column and choosing "data" - "text to columns"</p>
<p>Thanks,</p>
<p>Brian Koehler, PMP<br />
ITR Group Inc.<br />
651-757-4525</p>
<p>-----Original Message-----
From: Court3nay [mailto:<a href="mailto:tender+d1d5a33eff99008737465e5599f4ea541ac0f6859@tenderapp.com">tender+d1d5a33eff99008737465e5599f4ea541ac0f6859@tenderapp.com</a>]<br />
Sent: Monday, September 27, 2010 4:15 PM<br />
To: Brian Koehler<br />
Subject: Re: Include tags in the export file [Suggestions]</p></div>Brian Koehler