Map an item using functions

When you map items, you can use functions to create simple or complex formulas. The functions available are similar to functions in Excel and in some programming languages:

  • They evaluate general logic, math, text, dates, and arrays.
  • They let you perform conditional logic and transformations of item values, such as converting a text to uppercase, trimming text, converting a date into a different format, and more.

Access requirements

Expand to view access requirements for the functionality in this article.

You must have the following access to use the functionality in this article:

table 0-row-2 1-row-2 2-row-2 3-row-2 4-row-2 layout-auto html-authored no-header
Adobe Workfront package Any
Adobe Workfront license

New: Standard

Or

Current: Work or higher

Adobe Workfront Fusion license**

Current: No Workfront Fusion license requirement.

Or

Legacy: Any

Product

New:

  • Select or Prime Workfront plan: Your organization must purchase Adobe Workfront Fusion.
  • Ultimate Workfront plan: Workfront Fusion is included.

Or

Current: Your organization must purchase Adobe Workfront Fusion.

Access level configurations*

You must be a Workfront Fusion administrator for your organization.

You must be a Workfront Fusion administrator for your team.

For more detail about the information in this table, see Access requirements in documentation.

For information on Adobe Workfront Fusion licenses, see Adobe Workfront Fusion licenses.

Insert functions into fields

To insert a function into a field:

  1. Click the Scenarios tab in the left panel.

  2. Select the scenario where you want to map data.

  3. Click anywhere on the scenario to enter the Scenario editor.

  4. Click the field where you want to insert a function.

  5. Select the tab in the mapping panel that contains the function you want to insert.

    For information on mapping panel tabs, see Function overview

    1. Click the function name.

      Or

      Drag the function into the field.

  6. Configure the function parameters.

    For an explanation of function parameters, hover over the function in the mapping panel.

    For more information on functions and their parameters, see the articles under Function references: article index.

  7. Continue configuring the module, or click OK.

TIP
When you create a complex formula that you want to reuse in another field, you can click the field that contains the combination, use Cmd-A or Ctrl-A to select it, then copy and paste it into the other field.
recommendation-more-help

Example: Some data types prevent users from entering more than a certain number of characters. You can use the substring function to limit a value to a certain number of characters.

In this example, the substring function limits project name to 50 characters.

Example meeting length restriction

Nesting functions

You can nest functions within each other.

Example:

In this example, the substring function limits the trimmed project name to 50 characters.

Trimmed name

To nest a function:

  1. Click the field where you are creating a formula.

    This opens the mapping panel.

  2. Click the first function that you want to add. This is the function on the outside. If the following example, this is the substring function.

  3. In that function, click where you want the nested function to go. In this example, the nested function goes in the place of the first parameter.

  4. In the mapping panel, click the nested function. In this example, this is the trim function.

  5. Continue configuring the function as desired.

  6. Continue configuring the module, or click OK.

Use Google Sheets functions

If Workfront Fusion does not feature a function you want to use, but it is featured by Google Sheets, you can use it by following these steps:

  1. In Google Sheets, create a new empty spreadsheet.

  2. In Workfront Fusion, open your scenario.

  3. Add the Google Sheets >Update a cell module to the scenario.

  4. Configure the module:

    1. Choose the newly created spreadsheet in the Spreadsheet field.

    2. Insert your formula containing the Google Sheets function(s) into the Value field.

      You can use the output of preceding modules as usual.

      Use Google Sheets functions

  5. Insert the Google Sheets >Get a cell module to obtain the calculated result.

  6. Configure the module, using the same Cell ID that you used in step 4.

    Use Google Sheets functions

7e1891ad-4d59-4355-88ab-a2e62ed7d1a3