# Spreadsheet Formulas

### Why Spreadsheet Formulas 

The ability to write formulas to manipulate columns of data is a hallmark of any good spreadsheet tool. They allow you to create unique data transformations that are not easily captured in other point and click interfaces. 

### Mito Spreadsheet Formulas are different

Mito spreadsheet formulas work differently from Excel formulas in three keys ways:

1. Mito formulas can self-reference. For example, if you want to convert the column `Name` to Uppercase, you can write the formula `=UPPER(Name)` in the `Name` column itself. Not having to use helper columns helps you keep your dataframes clean. 
2. Mito formulas do not automatically refresh. If the data that a column formula references changes, simply resubmit the column in order to recalculate it on the most up to date data. 
3. By default, formulas apply to the entire column. If you enter a formula in a column, then it will autofill for all cells in that column. 

### Writing Spreadsheet Formulas

You can either write a spreadsheet formula in the formula bar or directly in the cells of the column you're looking to edit.

To write a spreadsheet formula in the formula bar:

1. Click on a cell in the column you want to set the formula of.
2. Double click on the formula bar to open it. 
3. Make sure that `Edit entire column` is set to `On`.
4. Write the formula and press `enter` to submit the formula.

You can also write a spreadsheet formula by double clicking on a cell in a specific column that you want to edit. The editing process is the same otherwise.

You can see a full list of the Mito Spreadsheet Formulas [here](https://docs.trymito.io/how-to/interacting-with-your-data/mito-spreadsheet-formulas). You can also learn how to add your own functions to the Mito spreadsheet [here](https://docs.trymito.io/how-to/interacting-with-your-data/bring-your-own-spreadsheet-functions).

![Writing a formula using the MONTH function from Excel.](https://2294704369-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MP_U5ZCmiamDOXEOOTC%2Fuploads%2Fjlpcqw6fW44hbWqELQgJ%2FScreen%20Shot%202023-11-29%20at%201.07.05%20PM.png?alt=media\&token=f37e704e-40c0-4c41-9b2d-15e63f0330cc)


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.trymito.io/how-to/interacting-with-your-data.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.