Recent content by Planner18

Thanks Julie. I finally understand. Appreciate your time explaining this. Cheers Planner18

Hi Julie, Thank you for your reply Just to be clear, if I wanted to set a resource working on a task at a 50% of their time at 85% availability, the only way is showing this, is to set the resource at 42%? As always thank you for your help and sorry to be a pain :) Regards Planner18

Hi Julie, Are you saying, even if I set the max units at 85% then, they still have to assign each resource on each task at 85% availability. Then over allocated will only be shown if they assign a resource on a task over 85%? I am bit confused because when a new resource is assigned to a task...

Hi The company planning standard states the resources in schedules must be set at 85% availability. The group has a resource pool which all the schedules are linked to. If the resources in the resource pool are set to 85% availability then the resources assigned to the tasks within the linked...

Julie, I used the formula in another text field and set the 'Calculation for task and group summary rows" to 'None' and the same problem occurred when new tasks were added. Then switched to 'use formula' and the output against summary tasks disappeared. Therefore, the formula gives me what I...

Julie, Many thanks once again. I did try that but it didn't seem to work. Maybe I mistyped it somehow. I will try again. It is strange I would have expected the same outcome setting "Calculation for task and group summary rows" to None. I'll will try your suggestion of using another text field...

Hi Julie, I'm using the following formula: IIf(IsDate([Finish])=No,"No Finish",IIf([Baseline Finish]=ProjDateValue("NA"),"No Baseline Finish",int([Finish]-[Baseline Finish]))) I tried introducing [Summary] = "Yes", " " in to this formula but keep getting errors. Can you show me please the...

Hi Julie, Having another problem with the formula. When I insert additional activities and task after baselining, the summary rows show an entry, even though I have set the 'calculation for task and group summary' and 'calculation for assignment rows' set to none, and I would like all summary...

Excellent idea as always Julie. Many thanks :)

Hi Julie, The reason is because PM's don't always have baseline dates in their table and when they include tasks following an agreed change they forget to baseline those tasks. All that finish variance shows is 0 days and does not give an indication that tasks have not been baselined which is...

Thanks John for your response. From previous posts, Julie is excellent at coming up with a solution to solve these little puzzles rather than going through the VB script route. However, if this is not possible and I try the approach you have suggested. Cheers And thanks Skip for additional...

Hello, I have been trying to use a formula from a previous post to measure the number of days between finish and baseline finish. The formula I have been trying to use is: IIf(IsDate([Finish])=No,"No Finish",IIf([Baseline Finish]=ProjDateValue("NA"),"No Baseline Finish",int([Finish]-[Baseline...

Thank you for your response. It is much appreciated.

Hi All, I'm looking for a formula that will change graphical indicators before 'todays date' with the following outcome. 10 days or more before todays date = green 10 to 6 days before todays date = amber 5 days or less before todays date = red 100% complete = blue. I hope I have explained...

Hi Julie, That works. Perfect! Thank you for your help Regards Planner