Search results for query: *

Thanks Julie for all your help.[bigsmile]

Hi Julie, The file contains restricted information so I can't send it to you unfortunately. How would I amend your formula 'IIf(IsDate([Finish])=No,"No Finish",IIf([Finish1]=ProjDateValue("NA"),"No Finish1",IIf([%...

Hi Julie I'm using 2010 :) I would be interested to know; - Even though it can't be shown, in the background, does project schedule in seconds or are minutes the lowest measurement? - Can the formula be amended so that it only compares between two dates and ignores minutes/seconds? Your help...

Hi Julie, I have pressed f9 and makes no difference. I know you can't view seconds in project but wondered if project calculates the difference at that level which could be the reason why I'm getting the unexpected results. I'm therefore asking can the code be amended so that it only calculates...

Hi Julie, I have a problem with the results of this formula. I copy all the task dates from finish to finish 1 and there are exactly the same right down to the minutes. However, the results I get are either 1, 2 or 3 and should be only 3. Any thoughts why? Is there a way this formula only...

Sorry Julie I don't know why I included 'date' must have had a bad day in the office. Anyway, your formula works great. Thank you for your help.

Hi Senorita, In my view, a 4000 line schedule is far to big to manage properly. I would be looking how the schedule could be consolidated or broken down into smaller more manageable chunks. Anyway, to see the predecessors and/or successors you need to insert two columns. Right click on any...

I have tried many variants using the following formulas as the basis but can't get the finish date is equal to finish date to work. Any suggestions? IIf([% Complete]=100,"0",IIf([Finish date]-[Finish1 date]>10,"1",IIf([Finish date ]-[Finish1 date ]>1,"2","3"))) switch([%...

Hi All, I'm new to the forum and don't know if anyone could help. I need a formula to be able compare the movement of two finish dates. For example; If task = 100% Complete then 0 If finish date is greater than finish1 date then 1 If finish date is less than finish1 date then 2 If finish...

Hi SkipVought, Apologies, I was trying to keep the same theme going. I will post a new thread. Thanks Gogglebox

Hi Julie, I'm new to the forum and don't know if you could help. I have a similar request to Planner18. I need a formula to be able compare the movement of two finish dates. For example; If task = 100% Complete then 0 If finish date is greater than finish1 date then 1 If finish date is less...