ÃÛ¶¹ÊÓƵ

DocumentationWorkfrontWorkfront Guide

Map items using functions in ÃÛ¶¹ÊÓƵ Workfront Fusion

Last update: Tue Jul 16 2024 00:00:00 GMT+0000 (Coordinated Universal Time)

CREATED FOR:

  • User

When you map items, you can use functions to create simple or complex formulas. The functions available in ÃÛ¶¹ÊÓƵ 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 ÃÛ¶¹ÊÓƵ Workfront Fusion.

Access requirements

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

ÃÛ¶¹ÊÓƵ Workfront plan
Any
ÃÛ¶¹ÊÓƵ Workfront license

New: Standard

Or

Current: Work or higher

ÃÛ¶¹ÊÓƵ Workfront Fusion license**

Current: No Workfront Fusion license requirement.

Or

Legacy: Any

Product

New:

  • Select or Prime Workfront Plan: Your organization must purchase ÃÛ¶¹ÊÓƵ Workfront Fusion.
  • Ultimate Workfront Plan: Workfront Fusion is included.

Or

Current: Your organization must purchase ÃÛ¶¹ÊÓƵ Workfront Fusion.

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

For information on ÃÛ¶¹ÊÓƵ Workfront Fusion licenses, see ÃÛ¶¹ÊÓƵ Workfront Fusion licenses.

Mapping tab overview

To open the mapping panel for a field:

  1. Click Scenarios in the left panel.
  2. Choose a scenario.

Mapping panel tabs

The following are tabs in the mapping panel:

Insert functions into fields

To insert a function into a field:

  1. Click the function name.

    Or

    Drag the function into the 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.

style
shade-box

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 ÃÛ¶¹ÊÓƵ 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.

5f00cc6b-2202-40d6-bcd0-3ee0c2316b43