In this video, see how to build a custom formula to display when your durations exceed your baseline estimate.
- [Narrator] Now that we understand some of the fields,…functions and operators within…the calculation dialogue box for custom formula,…we can go off and start to build our own.…Our team has asked us to build a custom duration field…to calculate the original duration to it's current duration…to see whether there's a variance.…We're going to go to the Custom Fields…on the Project ribbon.…We'll switch to the Task side,…since that's where they'd like to see it…on a per task basis.…And of course, we'll select the type Duration.…
We'll rename our Duration1 field to Duration Indicator…and we'll press OK.…Now we'll build out our formula to go with it.…So, we'll press the Formula button…and we'll use a field that comes out of the box,…so we'll go down to the insert options and select Duration…and next, Duration Variance.…Now we're setting a current custom field…equal to one that comes out of the box.…You might say…"Why are we doing this, because it's rather simple?"…Well, since the current duration variance field…that's in project, I can't edit it to do additional things,…
Note: This course was designed in collaboration with Bonnie Biafore.
- Touring custom field categories
- Working with enterprise fields
- Creating lookup tables
- Choosing custom fields
- Using custom fields to edit built-in fields
- Importing fields and formulas
- Creating formulas to edit text based on other fields
- Creating graphical indicators
- Choosing effective indicators
- Importing indicator criteria