This video covers importing a schedule variance formula that has been built in another project, using a Switch function.
- [Instructor] We've been very busy creating…multiple fields, custom fields, for this particular project:…at the project level, like our cost one here,…task level, where we looked at upcoming milestones,…and resource level, where we looked at the location…associated with that particular resource.…We want to return to our original table…and now create a schedule indicator…so that we'll know whether the schedule,…or task within the schedule, is moved off its plan.…We'll go to the View ribbon, and return by selecting…our tables, to go to the Finance Table.…
Here we can see we have our original fields,…like the Marked field that we selected for each milestone.…Since we're done selecting milestones,…we can right-click on that and hide it.…We'll also collapse the Task Name column just a little bit…to get a little more into the view that we want.…Now, as you can see, we've got several other fields in here,…the Duration Indicator that we'll use in a later video,…so we'll keep busy at building some additional fields.…
Note: This course was designed in collaboration with Bonnie Biafore.
Lynda.com is a PMI Registered Education Provider. This course qualifies for professional development units (PDUs). To view the activity and PDU details for this course, click here.
The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.
- 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