Forum Discussion
IIf formula in microsoft project custom field
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
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.
- Brent30,
Okay, if that works for you, then great. Thanks for the feedback.
John
