Column types

There are two types of columns in a Manasheet: input and output. Intput columns are denoted by a red asterisk in the header, and they must be filled in by the user before the corresponding row in the Manasheet can be executed. Column headers without a red asterisk are output columns, and they are automatically populated after the Manasheet is executed. Some output columns may be indicated as optional.

Column instructions

You can view the instructions for a column by clicking on the dropdown arrow in the column header. Build me a Manasheet that does...

Dependencies

Sometimes, you want the results of some columns to be used as the input for other columns. For instance, if you want to calculate the total cost of a list of items, you may want to multiply the quantity of each item by its price and sum up the results. To do this, you can reference the results of other cells by typing @ in the instructions, then a dropdown menu will appear with all of the columns you can refer to. You can include multiple columns as dependencies with a separate @ for each one. If a column has dependencies, they will not start running until all of the dependent columns have been executed.

Calling tools

You can call custom tools by typing / followed by the name of the tool you’d like to call. A dropdown menu will appear with all the available tools that you can call. If there is a piece of custom logic that you’d like to execute, but there is no custom tool for it, you are able to create the tool in the Tools page then call it here. See more about custom tools here.