EXCEL Flatten formulas function

This article describes the RPA Excel functionality to flatten formulas.

For a full list of available functions, please read EXCEL functions.

Description

The EXCEL Flatten formulas function allows you to flatten formulas.

Setting it up

To use the EXCEL Flatten formulas function, follow these instructions:

{{popups:rpas/add:action=excel-flatten-formulas}}

Once on a process map:

1. Navigate to the process where you would like to add the EXCEL Flatten formulas function
2. Click on the green button’s drop-down (right side of the green button labelled “Process”)
3. On the menu that appears, click on the “+ Activity” item
4. From here you can select the EXCEL Flatten formulas option
5. Click "Add" once you are done

Input parameters

Output variables

This action does not produce output variables.

Errors

Tips

• This replaces formulas with their calculated values
• Useful before sharing a file without revealing formulas

Related functions

• excel-formula
• excel-write