• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 9. Working with Custom Fields > Working with Formulas

Working with Formulas

Custom field formulas are powerful: They allow a user to set the value of a field as a function of the value of other fields. For example, you might want a custom cost field to represent the budget allotted for the completion of a given task. This value would be hand-entered by the project manager. A second cost field contains a formula that defines its value as the budget field minus the task's Actual Cost field. This field would represent the Remaining Budget amount for the task.

You can also use formulas to create new calculated fields that did not exist before. For example, there is no Remaining Budget field, but the example on the next page discusses the creation of a Budget field and a Remaining Budget field using a formula.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint