Need Help With a Custom Equation/Indicator MS Project 2007

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Project
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - fixed costs are not included in PV in MSPROJECT 2007 Dear all, When you want to use the EV in MS Project 2007 having both fixed costs and resource costs, this is what happens: The BCWS (=PV) is calculated in the Earned Value Table including both fixed costs and resource costs. However, when you go for "Visual Reports">"Earned Value" the Planned Value (PV) displayed gives only resource costs and ignores fixed costs. Any ideas? Tag: Need Help With a Custom Equation/Indicator MS Project 2007 Tag: 136791
  - 2
    - Hightlighting when there are multiple milestones on the same day Firstly, forgive me, I'm not very expert at using Project 2007! I have put together a master project from sub projects. Each of the sub projects have milestones which are 'Getting senior management approval' My master project then has each of these sub projects listed in turn, with the relevant tasks and miletones. My boss is pleased with it. But he now wants me to flag up any cases where two or more projects are seeking senior management approval on the same day. I thought of creating flag colums for each senior management meeting (but I'd need loads of these). Then I still don't know how to flag up that there's more than one milestone on a certain day. Any ideas? Thanks Tag: Need Help With a Custom Equation/Indicator MS Project 2007 Tag: 136788
  - 3
    - can I install project 2007 while using office 2003? All of our laptops are running XP pro with MS Office 2003. I want to know if I can install MS Project 2007 or do I need to purchase Project 2003. Tag: Need Help With a Custom Equation/Indicator MS Project 2007 Tag: 136787
  - 4
    - Sorting (eg by start date) keeping outline levels? My org is small and mainly uses MSP as a scheduling tool. We have the one master schedule, with all of the different programs broken down in that schedule. An example of what the task namecolumn looks like: Flores Trip â?? Preparation Transport and Accommodation Book Denpasar to Kupang, 2 people for 31/4/08 Book Kupang to Maumere, 3 people for 4/5/08 Admin. Prepare 2 x field folders Call Cooperative X to advise of date and location of training Find Map of Maumere and add to folder prepare 21 copies of training materials Flores Trip â?? Fieldtrip Transport Denpasar to Kupang Kupang to Maumere Maumere to Village X Timor Trip â?? Preparation Transport and Accommodation Book Denpasar to Kupang, 2 people for 31/4/08 Book Kupang to Denpasar, 3 people for 4/5/08 Admin. Prepare 2 x field folders Find Map of Kupang and add to folder Print 45 copies of training materials Timor Trip â?? Fieldtrip Transport Denpasar to Kupang Kupang to Denpasar Activities Kupang - Bookkeeping training Kupang â?? Confirm flight to Maumere Kupang â?? Organize driver for maumere to village Y. I have been trying to create different views for the information so that the tasks can be sorted by date and by resosrce. The problem is, how do you do it so that the different outline levels are kept? Now if I sort the info, for eg, by what the admin team have to do, I only get a list that looks like this (assume all 4 tasks have the same start date): Prepare 2 x field folders Prepare 2 x field folders Print 45 copies of training materials Print 21 copies of training materials The problem is that I need a column in the reports or different views that says whether the task is for the Timor or Flores trip. Is a way this can be automatically generated, or can each task be listed by both levels? Timor trip-preparation Prepare 2 x field folders Flores trip - preparation Prepare 2 x field folders Timor trip-preparation Print 45 copies of training materials Flores trip - preparation Print 21 copies of training materials, Or even better Timor trip-preparation Prepare 2 x field folders Print 45 copies of training materials Flores trip - preparation Prepare 2 x field folders Print 21 copies of training materials Thanks, Kate -- New to MSP MS Project 2003 Tag: Need Help With a Custom Equation/Indicator MS Project 2007 Tag: 136785
  - 5
    - Removing old programs superseded by new I'd like to clean out programs I don't use or that are old. In general, can you usually delete the earlier updates and leave just the most recent one? Or are they cumulative and the latest one relies on information delivered in earlier updates? (Example: I have Java 6 update 3, then Java 6 update 5, can I delete the earlier Java update 3?) Tag: Need Help With a Custom Equation/Indicator MS Project 2007 Tag: 136784
  - 6
    - Special Formatting to values in Project 07 Hi all, I'm curious if there's a way to format individual cells in Project 2007 based upon values? For example, I'm doing a calculation in a custom field that shows me the variance difference in last week's remaining work and this week's remaining work. If the variance difference is zero, then I really don't care to pay attention. If the variance is > 1 but < 8 hours, I'd like to highlight the cell background yellow. While if the variance is > 8 hours, then it needs to be red. As close as I've seen is the "text styles" where I could highlight based on "cell changes". Where a cell would be highlighted if it has changed... but this has serious (if not obvious) limitations. Any input is welcome! Kind regards, Mike Tag: Need Help With a Custom Equation/Indicator MS Project 2007 Tag: 136770
  - 7
    - MS Project: field text chars MS PROJECT: can u increase the # of characters (text) allowed in the resource initial field? Tag: Need Help With a Custom Equation/Indicator MS Project 2007 Tag: 136768
  - 8
    - what is a good program for doing construction remodeling estimates what is a good program for doing construction remodeling estimates? Tag: Need Help With a Custom Equation/Indicator MS Project 2007 Tag: 136766
  - 9
    - Baseline % Complete Column in Gantt View I am trying to show an expected % Complete based off the Baseline. Right now, I am able to show % Complete, but for management, I need to show where the baseline % Complete suggests we should be at this point. I've searched through the discussions and can't find one that explains exactly what to do or what formula needs to be used to accomplish this. Any help will be appreciated. Tag: Need Help With a Custom Equation/Indicator MS Project 2007 Tag: 136761
  - 10
    - Change collors 1. Can i mark free time other than the weekend with a specified collor? The weekend is now grey. I want all the other extra freetime (like holidays for example) in an other collor. 2. Can i also mark a task row with a collor? I want for axample mart task 10, 13 and 18 yellow (the row, not the tekst). Tag: Need Help With a Custom Equation/Indicator MS Project 2007 Tag: 136758
  - 11
    - More then one overtime rate Is it possible to work with more then one overtime rate? Ik want to work with 100% 125% 150% 175% 200% and 250%. I need to plan with overtime sometimes so i want these rate to calculate exactly. Tag: Need Help With a Custom Equation/Indicator MS Project 2007 Tag: 136756
  - 12
    - I want to Filter tasks&fit finish of summary to finish of its sub- Hi, I want to filter the tasks and fit the end of summary to end of its filtered sub-tasks , it means that i want to fit end of summary based on filtered task Tag: Need Help With a Custom Equation/Indicator MS Project 2007 Tag: 136755
  - 13
    - Copy Picture to Office Wizard in Project sorts resources Hi, I am using Project 2003, trying to generate a PowerPoint slide of my Gantt chart. When I use the Copy Picture to Office Wizard, it re-sorts the rows in my Gantt chart by resource name, which messes up the links between dependent tasks. The re-sort occurs immediately upon clicking the wizard button, and it even modifies the Project itself (once I'm through generating the slide, I go back to the Project and the rows have been rearranged as well). Is there a way to force the wizard to leave things alone and generate EXACTLY my layout and ordering? In the mean time I am using the Copy Picture to generate GIF images. Tag: Need Help With a Custom Equation/Indicator MS Project 2007 Tag: 136753
  - 14
    - Project Pro 2003 and 2007 on same PC Hello, Is it possible to install Project Pro 2003 and 2007 side by side on the same machine without any disturbance or mixture between the GLOBAL.MPT files? How can we do that ? Thanks Tag: Need Help With a Custom Equation/Indicator MS Project 2007 Tag: 136751
  - 15
    - Summary task % complete I have a project with about 700 tasks in it. SOME of the summary/rollup tasks do NOT show 100% even though all subtasks are 100% complete I have tried changing the % complete to 100% but it automatically changes back to 99% complete when I click on okay. There are no special constraints and some of the tasks update correctly. I have the options set to calculate automatically and I have no outside dependencies. Tag: Need Help With a Custom Equation/Indicator MS Project 2007 Tag: 136745
  - 16
    - Incompatibility between versions of Project 2000 vs Project 2003? I have a Project Plan created in MS Project 2003 and saved. I am collaborating with another person who has Project 2000. When he saves the file and I open it, I seem to be missing objects out of the Organizer. Are there any other problems that I should know about before I recommend the other person to upgrade at the same version I am using? Please help. Thanks. Tag: Need Help With a Custom Equation/Indicator MS Project 2007 Tag: 136733
  - 17
    - How to set custom size for "Reassign To" field ??? Hello, In My Tasks, i've create a task, then i'm trying to reassign this task to another resource and on that page Field "Reassign To" becomes TOO short if Task name is long, and i just cannot select apropriate resource because I only see 5-6 letters of their first name! Is it possible to set size of this field some how, otherwise its completely unusable. Was this QA'ed before release, it's obvious BUG! AZ Tag: Need Help With a Custom Equation/Indicator MS Project 2007 Tag: 136728
  - 18
    - How to assign the budget resources to project summary task in P 20 Hello Can you please help me with the above. The specific problem is to assign the reseource categories, e.g budget labour or budget materials to the project summary task. It is easy in Project 2007 but not in 2003. the budget check box which exists in 2007 does not exist in 2003. All the best Feras Tag: Need Help With a Custom Equation/Indicator MS Project 2007 Tag: 136726
  - 19
    - Muliple Instances of Project I have a dual monitor setup on my desktop computer. I want to open two instances of MS Project 2007 side-by-side so that I work on them. When I try to open the 2nd instance of Project, it activates the 1st instance. Is there any way around this..? Thanks, D -- draff ------------------------------------------------------------------------ draff's Profile: http://forums.techarena.in/member.php?userid=15425 View this thread: http://forums.techarena.in/showthread.php?t=952172 http://forums.techarena.in Tag: Need Help With a Custom Equation/Indicator MS Project 2007 Tag: 136724
  - 20
    - Secured Global.mpt for MSP2007std Hello All, I have several independent installations of MSP2007std. They will be sharing plans and resources, and viewing a master(consolidated) schedule file comprising inserted projects. I want the option settings for each installation to be universal, and that views table etc are common throughout. I also need to take control of the master settings to prevent damage and enforce standards. I think I need to do this to prevent incorrect alendar and resource changes. As far as I can tell some settings are in global.mpt (Options menu items), some are saved in each project file (eg view print settings), and some can be replaced in the file via organizer. I have have noted Rod Gill's suggestion to place global.mpt in a central location and have the MSP shortcuts setting redirect "Start in" to that location. However, that allows the user to modify the original file (some have admin rights). As an alternative, I was considering a batch file that overwrites the local global.mpt with a standardised version, retrieved from a central location. This batch file would be placed in all users' Windows Startup so it would occur each time Windows was started. Any inadvertant changes would then be remedied each startup. Does the location of the local global.mpt vary with updates etc? Does this seem a feasible solution? Is there a better way? Server version is not an option for us. Extra est AUD11000 for three users. Gulp. Regards, Adam Tag: Need Help With a Custom Equation/Indicator MS Project 2007 Tag: 136716
  - 21
    - how to access data from a summary task Hi everyone, I'm trying to create a task custom field in project 2007 that uses data from a summary task, and if it is a summary task it must get the value at project level. The fields are Name: project weigh Entity: project Type: number Name: task weigh Entity: task Type: number Name: task weigh calculated (the field that i have problems with) Entity: task Type: number formula: if it is a sumary task = [task weigh]*[project weigh] if it is not a sumary task = [task weigh] * [task weigh calculated] of the sumamry task that the task belongs to. the formula for the summary task is easy to do, but how can i get the value of a summary task from a task? thaks for your help, Jose X Perez Tag: Need Help With a Custom Equation/Indicator MS Project 2007 Tag: 136710
  - 22
    - Why Do Summary Tasks Show Incorrect Totals? I can't seem to get summary taks to display correct durations, and yes, I know it's supposed to be from the start date of the first task to the end date of the last task. Here's an example from adding a recurring task (Monday update meeting) to a project. The span is 35 days. The summary task shows a duration of 105.13 days. Remodel Status Meeting 105.13d Mon 4/21/08 Mon 5/26/08 Remodel Status Meeting 1 1h Mon 4/21/08 Mon 4/21/08 Remodel Status Meeting 2 1h Mon 4/28/08 Mon 4/28/08 Remodel Status Meeting 3 1h Mon 5/5/08 Mon 5/5/08 Remodel Status Meeting 4 1h Mon 5/12/08 Mon 5/12/08 Remodel Status Meeting 5 1h Mon 5/19/08 Mon 5/19/08 Remodel Status Meeting 6 1h Mon 5/26/08 Mon 5/26/08 Another summary task in a different project shows a duration of 0.38 days for 6 tasks totaling 16 hours of fixed work for one person working a standard calendar and work week. The resource is otherwise unassigned. The work column totals correctly, just not the summary task duration. Wed 1/2/08 0.38d Fixed Duration 16h Wed 1/2/08 3h Fixed Work 3h Wed 1/2/08 3h Fixed Work 3h Wed 1/2/08 3h Fixed Work 2h Wed 1/2/08 3h Fixed Work 3h Wed 1/2/08 2h Fixed Work 2h Wed 1/2/08 3h Fixed Work 3h Thanks for any advice you can offer. Tag: Need Help With a Custom Equation/Indicator MS Project 2007 Tag: 136704
  - 23
    - On MS Project 2007, how do I set a task as a subtask? I know how to doit on 2003, but I can't find the demotion arrow in the new version Tag: Need Help With a Custom Equation/Indicator MS Project 2007 Tag: 136699
  - 24
    - Limiting the view through Project 2007 Hi, How do you remove the closed projects from your view in full client through Project 2007? When I close a project, the project still shows up in the full client view. Thanks, -- Barbara Tag: Need Help With a Custom Equation/Indicator MS Project 2007 Tag: 136695
  - 25
    - Page Formatting I have tried a number of suggestions to stretch a schedule's timescale over the full page width of an 11 x 17. As others have found, the font can get incredibly small if the duration of the schedule is excessive. I have been able to overcome this to an extent by changing the font size using Format:Text Style. However, I always seem to get to a point where Project decides to adjust the duration rather than the font size. For instance, my duration is 440 days and my print out is looking pretty good, covering the whole page. I decide to enlarge the font for the column headers and when I next do a print preview, the displayed duration has increasaed to 880 days. Neither my timescale scaling factor in page setup or my print range have changed, but my preview shows a lot of white space on the right half of the page and my scheduel scrunched into infinitessimally small fonts on the left side Is there anyway to lock the time scale so it covers the full page width? -- Paul Tag: Need Help With a Custom Equation/Indicator MS Project 2007 Tag: 136692
- Next
  - 1
    - Strange characters in text field Anyone seen strange characters (ì¬?, ì±?...etc) in their schedules? I am using MSOP 2007, a resource pool and an IMS. These characters do not appear in the individual .mpp file or the IMS. They only appear in the resource pool and only in one of the text fields. Any thoughts?? Tag: Need Help With a Custom Equation/Indicator MS Project 2007 Tag: 136691
  - 2
    - Project Tasks and some of the other attributes gets deleted We are using Projects Standard 2003. We observed that some of the lowest level task Names and Task attributes are getting deleted after saving and opening the project plan file. However, Predecessor and Dates are not deleted. Can someone advise on this pls? Thanks in advance, Tag: Need Help With a Custom Equation/Indicator MS Project 2007 Tag: 136688
  - 3
    - Assign man hours to each task How do I assign man hours to each task in my schedule? Task are listed as Fixed Duration and I unchecked Effort Driven. Added resource to represent crew of 4. Task is twenty days. Now how do I enter Manhours for this task? Tag: Need Help With a Custom Equation/Indicator MS Project 2007 Tag: 136687
  - 4
    - using a formula in a customized field...syntax problem? I have created a formula in a customized field to collect costs in the Task table. I want to be able to apply a factor to the cost of a â??laborâ?? resource and not to a â??materialâ?? resource. I thought I could get it to work by using one or the other of the following syntax statements: IIf([Resource Type]="Work",[Cost]*(1+1.64),0) IIf([Type]="Work",[Cost]*(1+1.64),0) The above syntax statements did not work. The way I got it to work was to insert a name in the Resource table in the Resource Group field called â??Supplierâ?? for material. I then used the following syntax: IIf([Resource Group]<>"Supplier",[Cost]*(1+1.64),0) My problem is that basically I am lazy and donâ??t want to have to type in the text â??Supplierâ?? in the resource group field for my materials on the project. Any thoughts on what I might be doing wrong? Tag: Need Help With a Custom Equation/Indicator MS Project 2007 Tag: 136680
  - 5
    - Task Names Disappearing in Project 2007 I have a smaller project (< 500 tasks). Task names have started to disappear. The tasks are still in the plan. The tasks are complete, and the dates are still in teh task information, but the task names have disappeared. Has anyone seen this problem and have an idea what is going on? Tag: Need Help With a Custom Equation/Indicator MS Project 2007 Tag: 136675
  - 6
    - Notes Text Disappearing in Project 2007 I have a relatively small project (< 500 tasks). I have notes for a numebr of the tasks, but the notes text have disappeared. The icon is still displayed, but when I open up task information, the notes tab is completely empty. Has anyone seen this problem in Project 2007? Any ideas how to prevent it? Tag: Need Help With a Custom Equation/Indicator MS Project 2007 Tag: 136674
  - 7
    - Master Project File Is there a way to insert subproject into a master file and have the subproject file maintain it's formatting, i.e. Task bar colors? SteveC Tag: Need Help With a Custom Equation/Indicator MS Project 2007 Tag: 136671
  - 8
    - Successors / Predecessors I have to use two projects for the activities that are ongoing. Is there a way to link successors / predecessors in the two projects. Basically it is a pipeline job and I have civils work to be done prior to mechanical/pipework. The mechanical part obviously cannot start until the civils work has been done. I'd like to link them if possible to FS / SS. Thanks Tag: Need Help With a Custom Equation/Indicator MS Project 2007 Tag: 136660
  - 9
    - Network Diagram Hello Please can you tell me what is the Network Diagram mainly used for? Many thanks Tag: Need Help With a Custom Equation/Indicator MS Project 2007 Tag: 136659
  - 10
    - Insert Ms excel 5.0 Dialog what is the use of abouve function. Tag: Need Help With a Custom Equation/Indicator MS Project 2007 Tag: 136652
  - 11
    - Project Management Tasks (to be excluded from the critical path) As part of my project, most of the tasks are sequential and inter-linked (as normal). However, I want to have some tasks sit separate from these tasks because they are Project Management (PM) tasks. These tasks exists as "support tasks" to the other tasks. For example, for every week that the project runs, I will need 2 hours a week assigned to the "Project controls and reporting" task. Currently I've got it set up in a basic way. I've budgeted for a 6-week project so my PM tasks are sitting at the top of the Gantt chart as 6-week tasks. However, there are two obvious problems: 1. These tasks are set at 6 weeks, and the total duration of the rest of the project is only about 5.5 weeks at the moment. This means that I am planning to do 0.5 weeks of PM tasks after the project has already finished! How can I restrict the end of this task? I've tried setting up a finish-finish relationship with a "project complete" milestone task (one that is complete once all the functional tasks are complete) but this moves the whole PM task along. This seems strange to me since the task is not "fixed-duration". 2. Because these projects have the latest finish date and start on the project start date, they all make up the critical path. However this doesn't make sense, since they only are running while other tasks are running. How can I exclude them from the critical path calculation? How can I set up Project like this? I would imagine lots of people want to do something similar to this. Thanks Atreides Tag: Need Help With a Custom Equation/Indicator MS Project 2007 Tag: 136647
  - 12
    - automatic resource assignment I have what I believe to be an extremely common situation. I have a dozen programmers. For the purpose of this question, assume them to be interchangeable. Each has his own availability (due to hiring dates, other projects, ramp-up times) which I think I know how to represent in the resource information. Each also has assorted other obligations (support, review participation, meetings, etc) that I also think I know how to represent as tasks. All of these people are capable of a reasonable degree of multi-tasking. I also have a bunch of new development tasks that need doing, and to a first approximation it doesn't matter who does which of them. I would love to be able to tease Project into assigning tasks to resources, based on the available time that each resource has. I haven't seen a way to do this. I can make my own assignments, but I have to specify how much each person will work on the task. This is not a fixed number ... as each person has a different number of available hours each week (due to availability dates, ramp-ups, and other responsibilities). I would at least like to get Project to apply "the available hours" to a task ... but I cannot find a way to do this either. Essentially, it seems that I have to decide who will work, how much, on each task, starting when ... after which Project will be happy to print beautiful reports. Figuring out who should work, on which task, starting when, seems to be my problem. This seems a pretty common problem (it is one I've had continuously for the last thirty years) and yet I can't find discussions of it, nor have I seen sample projects that seem to address these issues. In a (surely different, but) related problem, I have deliberately assigned only a small fraction of a person to a task (knowing that they will have at least that much time available). Whether the task is fixed unit or fixed work, I often find that applying someone 10% time to a 25 day task, results in them doing four hours per week of work for five weeks after which the task is shown as completed ... (in only 20 hours of work). Apparently I don't understand when a duration is a start-to-end day count, and when duration is a number of staff-days. Tag: Need Help With a Custom Equation/Indicator MS Project 2007 Tag: 136645
  - 13
    - Performances and Calendar Hello, friends. I wish to make projects mainly with musicians, dancers and other resources that will only be paid for the performance and not for 'hour'. Another resource group will work also not for hour, like producers and assistants... but for the whole project. I also will have some standard workers, working on the 'Standard' calendar. Would someone be so kind to suggest a way to managge this in project 2007?? Tag: Need Help With a Custom Equation/Indicator MS Project 2007 Tag: 136636
  - 14
    - Tasks, hours and resources view I'm fairly new to Project and I'm trying to get it to display a view that is commonly used for setting up or estimating projects. What I want to see is a view with tasks on one axis, resource names on the other and then allocation of hours to each task as the table data. For example: Bob Jane Alice ... Task 1 10h 10h Task 2 5h 5h Task 3 2h 10h 10h ... Can I do this? Tag: Need Help With a Custom Equation/Indicator MS Project 2007 Tag: 136635
  - 15
    - Compatible software with MS Project 2007 Is there a list of compatible software with Project 2007? I spent some time looking at Adobe's site to find out that PDF Maker isn't compatible with Project 07' unless you have version 8.1. Does Microsoft furnish a list of commonly used software and what versions are compatible with Project 2007? Tag: Need Help With a Custom Equation/Indicator MS Project 2007 Tag: 136630
  - 16
    - Language mixture Today I installed english versions of MS Project 2007 and Project 2003 on a PC, were previously a german version of Project 2003 was installed. Both english versions are working fine, but the are showing in some menus (e.g. "Filters" and "Views") elements of the older, not longer existing german version. This mixed user interface is confusing. How can I remove the old text elements? Regards Claus Tag: Need Help With a Custom Equation/Indicator MS Project 2007 Tag: 136624
  - 17
    - Max. Units Field@ MS Project Professional 2003 How can I define Max. Units of Resources field column in Gantt Chart. Thanks. -- Sam toronto3330@yahoo.ca Tag: Need Help With a Custom Equation/Indicator MS Project 2007 Tag: 136623
  - 18
    - Project server to MPP file I am using Project Pro 2003 with the server. I had a project on my hard drive that crashed without a backup....I know! I would like to extract the project information from the server back to my PC and create a new MPP file. Can it be done? Thanks David Tag: Need Help With a Custom Equation/Indicator MS Project 2007 Tag: 136620
  - 19
    - "Operation failed" when mapping fields from Excel data When importing Excel data into Project 2003, I click Finish on the field mapping wizard. I then get an "Operation failed" message. This action has worked fine for many months, but recently began to fail. This concided with a the recent round of security patches pushed down from Microsoft. Both files are on the local machine, and are both from Excel and Project 2003 versions. The error will appear whether I use existing or create new maps. Tag: Need Help With a Custom Equation/Indicator MS Project 2007 Tag: 136619
  - 20
    - Print more then one rapport Is it possible to print more then one (or all) reports? I want to print a copple of rapport of a project. Now a have to select them all en print them one by one. Is there any other way to do this? Thanks Tag: Need Help With a Custom Equation/Indicator MS Project 2007 Tag: 136616
  - 21
    - Variable Task Duration I am trying to assign a span of time for a specific task. For example 10-20 days for a task. I can't seem to figure out how to do this - is it possible? If so, how? Robbin Tag: Need Help With a Custom Equation/Indicator MS Project 2007 Tag: 136613
  - 22
    - TINA - Different calendars in one project Hi ... I have a project where I am using 2 different calendars ... one is 7 days a week from 8 to 6 1/2 hour lunch and the other is 5 days a week 7 to 5 1 hour lunch ... I put the 'most common' calendar in as the 'project calendar' and then for any individual tasks that required the 2nd calendar, I applied it as a 'task calendar' ... and yet when you turn on time on the start and end columns, you do not see the time change ... the durations go into decimals (and I have the tools/options/calendar tab in sync with the project calendar) ... am I doing something wrong or is there a sequence of events? The other alternative was to break the project down into 2 small projects and let them have their own calendars as project calendars and then bring them together in a consolidated project? Any suggestions would be appreciated ... thanks, Tina -- Thanks!! T. Marie Tag: Need Help With a Custom Equation/Indicator MS Project 2007 Tag: 136605
  - 23
    - Project 2000 compatibility with Project 2007 At work we have Project 2000 but I may buy Project 2007. Will the people who have Project 2000 being able to open and read any documents I send them if I have created them in Project 2007? Tag: Need Help With a Custom Equation/Indicator MS Project 2007 Tag: 136604
  - 24
    - comparing projects across versions Any way to compare a 2007 project file to a 2003 project file? I need to see what has changed on projects that I convert over to 2007. Tag: Need Help With a Custom Equation/Indicator MS Project 2007 Tag: 136603
  - 25
    - problems converting 2003 projects to 2007 We are converting our 2003 projects (very large and linked across projects) to 2007. Any known issues that we should be aware of? Tag: Need Help With a Custom Equation/Indicator MS Project 2007 Tag: 136601

I am having issues writing a custom equation in MS Project 2007 that
can
put an indicator next to any task that is due from the current date to
+14 days forward. Does anyone have any experience with this?

Thanks In Advance,
Jonathon

Top

Re: Need Help With a Custom Equation/Indicator MS Project 2007 by Jack

Jack
Fri Apr 18 09:18:03 CDT 2008

should be pretty simple with an iif statement

This for example shows some text for any uncomplete tasks due within the
next 14 days. It also captures any which were overdue but you can modify
that by adding another condition

IIf([% Complete]<100,IIf([Finish]<([Current Date]+14),"This is due within 14
days",""),"")

-Jack Dahlgren
http://zo-d.com/blog

"Jonathon" <jonathon.levin@gmail.com> wrote in message
news:93828251-e87c-4067-951c-1c312388bc41@m71g2000hse.googlegroups.com...
>I am having issues writing a custom equation in MS Project 2007 that
> can
> put an indicator next to any task that is due from the current date to
> +14 days forward. Does anyone have any experience with this?
>
> Thanks In Advance,
> Jonathon

Top