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