---
title: "Using the Set Formula Value Step"
slug: "using-the-set-formula-value-step"
updated: 2021-03-12T15:05:29Z
published: 2021-03-12T15:07:13Z
canonical: "documentation.decisions.com/using-the-set-formula-value-step"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://documentation.decisions.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Using the Set Formula Value Step

Example Lab ArticleWhile Example Lab projects are resources for public use, articles and assets are not actively maintained. Screenshots and features are from the specified version below. These references may become dated as new versions are released.

---

## Overview

| ## Example Lab Details |
| --- |
| **Version** | 6.10.2 |
| **Root Folder** | Example Lab-Using Set Formula Value Step |
| **Modules** | None |
| **Dependencies** | None |

This Example Lab project demonstrates how to use the **Set Formula Value** step to populate data in an excel spreadsheet using a formula.

---

## Explanation

This Flow starts with the **Create Data** step. **Create Data** Step contains a file data variable that is set to a constant. An excel template is uploaded to this variable. The **Set Formula Value** step is used to add a value to a cell of the excel file using a formula. The inputs for this step are the following: **Column**, **File Type**, **Input**, **New Value**, **Row**, **Worksheet Number**. For this example we have set the **Column** to 1, **File Type** to Auto Select, **Input** to the uploaded file from the **Create Data** step, **New Value** is set to the formula of “1+4”, **Row** is set to 0 and **Worksheet Number** is set to 0. This will populate the value of 5 in the first cell of the excel file. The **Update File With Data** step is updating the excel file with the data that is modified with the **Set Formula Value** step. The **Download Updated Excel** Form takes in the output of the **Update File With Data** step as an input and is used to download the updated excel file.

Reference Articles[Edit And Update Excel Document](https://documentation.decisions.com/docs/edit-update-excel-document)  
[Creating And Styling Excel Document](https://documentation.decisions.com/docs/creating-styling-excel-document )

![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/ExampleLab%5BExcelFormula%5D.png)

---

## Project Download

The examples attached were developed to be instructional and were not developed as officially supported components. For more information or to engage our service team to develop fully supported, production quality solutions, please contact services@decisions.com. Import the project below to a Decisions environment on version 6.10.2 or later using our [Importing/Exporting](https://documentation.decisions.com/docs/exporting-and-importing-overview) article.  
  
  
[ExampleLab[UsingSetFormulaValueStep].zip](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/ExampleLab%5BUsingSetFormulaValueStep%5D.zip)  

---