Map items using functions in Adobe Workfront Fusion

When you map items, you can use functions to create simple or complex formulas.

The functions available in Adobe Workfront Fusion 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. For more information, see Map information from one module to another in Adobe Workfront Fusion.

Access requirements

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

Adobe Workfront plan*
Pro or higher
Adobe Workfront license*
Plan, Work
Adobe Workfront Fusion license**

Current license requirement: No Workfront Fusion license requirement.

Or

Legacy license requirement: Workfront Fusion for Work Automation and Integration

Product

Current product requirement: If you have the Select or Prime Adobe Workfront Plan, your organization must purchase Adobe Workfront Fusion as well as Adobe Workfront to use functionality described in this article. Workfront Fusion is included in the Ultimate Workfront plan.

Or

Legacy product requirement: Your organization must purchase Adobe Workfront Fusion as well as Adobe Workfront to use functionality described in this article.

To find out what plan, license type, or access you have, contact your Workfront administrator.

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

Insert functions into fields

If you click a field, the mapping panel displays. The mapping panel contains several tabs:

The first tab (shown upon opening the panel) displays the items that you can map from other modules.

The other tabs contain the following types of functions:

To insert a function into a field:

  1. Click the function name.

    Or

    Drag the function into the field.

INFO
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.

Nesting functions

You can nest functions within each other.

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.

    For instructions on adding a module, see Add a module in a scenario in the article Create a scenario in Adobe Workfront Fusion.

  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.

  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.

recommendation-more-help
5f00cc6b-2202-40d6-bcd0-3ee0c2316b43