Recent content by lauriebizz

The confusing part is the requirement ID could have multiple regression test plans. If the regression test plan a for xyz has passed, then it needs to indicate passed. However if test plan b for xyz has failed, then it needs to indicate failed. I'm some what confused myself, as I'm helping...

I have a simple spread sheet that lists reqirement number (D:D) and a testing status (C:C) (No Run, Passed, Completed). I need a fomula that returns the Requirement Number with the status of the lowest status. I created the string below to assign a numeric value to the status. =IF(C119="No...

Good question Johnherman. I have a client that is implementing 11 sites; they would like to see the dates for each site side by side in a project plan.

Project 2010 Created custom Start Date 1 and Finish Date 1 -- how do I calculate the duration in whole days? It seems that for Duration : if I subtract Finish Date 1 from Start Date , I get a decimal number. I'm sure it's simple and I'm way over thinking it. Thanks Laurie

I found the solution here: http://www.tek-tips.com/viewthread.cfm?qid=405157&page=1 Though admittedly, I haven't tried it yet. Thanks- Laurie

Ah, I found a thread that answers my question. Thanks!! Laurie

Great, so how do I show an attribute in a cell? I know I'm over-thinking it... Thanks- Laurie

I should clarify - the document version, not the version of excel. Thanks- Laurie

Is there a way to auto create a version # in a workbook. Then insert to display in a cell? Thanks- Laurie

Pending on what version - I have '07. Typically, I use the Update Project at Tools -> Tracking -> Update Project and reschedule incomplete tasks to today's date. I do this with my 'template' plan when starting a new project. HTH Laurie

Is there anyway to add risk to a project in '07 without project server. I have several xls files, but I have several projects and it would be easier to have risk in the same place as the WBS. Thanks!! Laurie

Have you thought of Google sync? It sync's contacts and calendars.

Correct - the hyperlink does not work. Yes, the documents are all stored on the same server. I've cleared out my temp directory.... when I hover over the link, it looks fine. However, when I edit the link I get the link BR01_Ded%20OOP%20Footnote/Ded%20OOP%20footnote.xls -- which of course...

I'm not sure I've ever had this problem. I'm using Word 2003 sp3 - when I hyperlink a phrase to a document on anther server, I end up having a temp link. For instance I'm linking to this path: \\IS_Project_Folders\1-SOW\BR01_Ded OOP Footnote\Ded OOP footnote.xls and end up with this...

Thanks! Laurie