Forum Discussion
IIf formula in microsoft project custom field
Thank you Dale_HowardMVP ! It worked perfectly! Thank you very much for your step by step instructions!
Do you also know how I can adjust the formula so the summary tasks and parent tasks have an "n/a" as well? (on the picture these are the bold tasks "Phase 1" and "Planungsphase 1")
Sure do. Open the project in question, then display the Custom Fields dialog. Select the custom Text field in which you created the formula. In the Calculation for Task and Group Summary Rows section of the dialog, select the Use Formula option. Click the OK button. Hope this helps.
- Brent30,
Okay, if that works for you, then great. Thanks for the feedback.
John John - So for this project file, this is not a typical project phased type model. What i am being asked to build is a single-file schedule with small (8-12 lines) individual repair efforts for various locations; each with its own PoP end dates set a deadlines. Each of these repairs would roll up to its own summary, so at the summary level, it would provide easy visibility into the target deadline for each repair vs. current status of each. For tasks that are 100% complete, the total slack field at the summary level will not ignore 100% completed tasks, but i have now found a formula that works well for this when applied to a custom duration field, so my initial issue has been resolved.
If I may step in. When you say you have a "schedule with multiple, individual schedules", are you referring to a dynamic master with inserted subprojects? And when you say, "each with its own deadline", where are you setting the deadline? A before and after screen shot would help.
What is your end goal? Keep in mind that summary lines are NOT tasks. As such total slack at summary level is a dubious metric.
John
- Hello Dale! Thank you for your willingness to help me out with a problem I have been dealing with. I am working a schedule with multiple, individual schedules - each with its own deadline. For a summary management view, I want to be able to display the amount of positive or negative slack rolled up to each summary on the individual schedules. Since the embedded Total Slack field is a feature provided by Microsoft Project and calculates specifically to minimum slack, this presents a conflict for me. If I "mark on track" any activities that are scheduled to be completed, the total slack for these tasks automatically show "0 days". The problem with that is:
Remaining tasks under the same summary are also late and accurately display negative float (less than 0 days) but because the embedded total slack field uses the completed tasks to calculate remaining float, the summary is then changed and presents a false picture at the summary level. I have built a custom "duration" field to recognize total slack so that I could change the roll up from maximum to Minimum (or vice versa), but this also presents a conflict since the roll up calculates one or the other. Therefore, my summary level view is not reliable. I need a custom field that can summarize the float on ONLY tasks that are less than 100% complete and ignore those tasks which have been marked 100%.
