Can monday.com formulas calculate across boards?

monday.com can support some cross board scenarios using Connect Boards and Mirror Columns. For more advanced cross board calculations, Spreadsheet Gorilla can provide a spreadsheet style setup that works across multiple boards and can update target board columns.

What is the difference between a Formula Column and a custom formula?

A monday.com Formula Column calculates values directly inside a monday.com board. A Spreadsheet Gorilla custom formula is created inside a spreadsheet template and can use board data in a spreadsheet style workflow before updating a target monday.com column.

Can I update a normal monday.com column with a formula result?

Yes. Instead of only displaying a calculated value, you can write the result into a regular monday.com column.

Can I calculate totals from another board?

Yes. For example, you can calculate invoice totals, ticket counts, tracked hours, task counts, budget usage, or other values from related board data.

Can I preview formula results before updating monday.com?

Yes. Previewing is important because it lets you check calculated values before they are written back to monday.com items.

Can I bulk update several items at once?

Yes. Once the formula has been tested and the previewed values are correct, you can update several items in one workflow.

Should I use Spreadsheet Gorilla for simple same board formulas?

Usually, no. If a simple monday.com Formula Column solves the problem, that may be the simpler option. Spreadsheet Gorilla is more useful when the calculation involves multiple boards, custom formula logic, lookup style calculations, or updating target columns.

How do I use formulas across monday.com boards to update board columns?

Need formulas to calculate across multiple monday.com boards? Spreadsheet Gorilla lets you calculate values with spreadsheet Excel style formulas and update board columns from the result.

Use the navigation to quickly jump to your desired section and learn more about each option or head straight to the conclusion.

Teams often manage related data across multiple monday.com boards. Projects may live on one board, invoices on another, time entries on another, and support tickets somewhere else. That structure works well for managing work, but it can become difficult when you need to calculate values across boards and write the result back into a monday.com column.

Native monday.com formulas can work for simple calculations on one board. But when the calculation depends on data from several boards, you may need a spreadsheet style workflow. Spreadsheet Gorilla lets you organize monday.com board data in spreadsheet templates, calculate values with formulas, preview the result, and update monday.com board columns with the calculated output.

Using formula columns

Can monday.com calculate formulas across boards?

monday.com can support some cross board scenarios with Formula Columns, Connect Boards Columns, and Mirror Columns. This works well when the calculation is simple and the related data is already available on the board. Use native monday.com formulas when:

The calculation only uses values from the same board
The related data is already connected
You only need one or two mirrored values
You do not need to update many target items
You do not need a reusable spreadsheet template

Native formulas become harder to manage when the calculation needs data from several boards, lookup logic, totals from related items, or a controlled way to write results back into normal monday.com columns.

How to calculate across boards with formula columns

Open the board where you want to include the cross board calculations
Add a Connect boards column along with its Mirror columns for each board
Add a Formula column and create the function manually or with the AI assistant
Iterate on the formula function until the results match your expectations
Collapse each Connect boards and Mirror column to keep your board clean

Using Spreadsheet Gorilla

When to use Spreadsheet Gorilla for cross board formulas

Use Spreadsheet Gorilla when you need to calculate across monday.com boards and update a board column with the result. It is useful when:

The source data lives on more than one board
You need Excel spreadsheet style formulas
You want to use lookup, sum, count, or conditional logic
You want to preview results before updating monday.com
You want to bulk update several items
You want to avoid adding many helper columns to your boards

Spreadsheet Gorilla for monday.com acts as a calculation layer between your monday.com boards and the final column you want to update.

How the general workflow looks like

1. Choose the value you want to calculate

Decide exactly what the formula should return. For example, total invoiced amount, remaining budget, or number of open tickets.
2. Choose the source boards

Select the boards that contain the data needed for the calculation. For example, a Projects board and an Invoices board.
3. Choose the target board and column

Decide where the final calculated value should be written. For example, update the “Total invoiced” column on the Projects board.
4. Create a Spreadsheet Gorilla template

Use a spreadsheet template to organize the monday.com board data before calculating.
5. Add the required boards and columns

Include only the boards and columns needed for the formula.
6. Create the formula

Add the formula that calculates the value.
7. Preview the results

Check the calculated values before updating monday.com.
8. Update the target column

Write the calculated values back into the selected monday.com column.

Most cross board formula workflows follow this basic process. For detailed formula setup, use the Spreadsheet Gorilla docs on custom formulas.

Use case + Example

Calculate total invoice amount per project

This is one of the most common cross board formula examples. A team manages projects on one board and invoices on another board. Each invoice is connected to a project. The team wants the Projects board to show the total invoiced amount for each project.

Goal

Calculate the sum of all relevant invoices for each project and update a “Total invoiced” column on the Projects board.

Example boards

Projects board
Invoices board

Example columns

On the Projects board:

Project name
Total invoiced

On the Invoices board:

Invoice amount
Invoice status
Connected project

How to calculate total invoiced amount per project

Open Spreadsheet Gorilla

Open Spreadsheet Gorilla and create a new spreadsheet template for the invoice calculation.
Add the Projects board

Add the Projects board to the template. This is the board that contains the target items you want to update.
Add the Invoices board

Add the Invoices board to the same template but to another worksheet. This is the board that contains the invoice amounts.
Select the required columns

Include the project identifier, invoice amount, invoice status, and connected project reference.
Create the formula

Create a formula that finds the invoices connected to each project and sums the invoice amounts. If only approved or sent invoices should count, make sure the formula only includes invoices with the right status.
Preview the calculated totals

Check the calculated total for several projects before updating monday.com.
Select the target column

Choose the “Total invoiced” column on the Projects board as the target column.
Update the project items

Update the Projects board so each project receives the calculated invoice total.

After the update, the Projects board contains a normal monday.com column with the total invoiced amount. That value can then be used in views, reports, dashboards, filters, or automations. Need the calculated data in an Excel report instead of writing the result back to monday.com? Learn how to create cross board Excel reports from multiple monday.com boards or learn how to create and export project profitability reports.

Questions + Answers

Frequently asked questions about cross board calculations

Can monday.com formulas calculate across boards?

monday.com can support some cross board scenarios using Connect Boards and Mirror Columns. For more advanced cross board calculations, Spreadsheet Gorilla can provide a spreadsheet style setup that works across multiple boards and can update target board columns.
What is the difference between a Formula Column and a custom formula?

A monday.com Formula Column calculates values directly inside a monday.com board. A Spreadsheet Gorilla custom formula is created inside a spreadsheet template and can use board data in a spreadsheet style workflow before updating a target monday.com column.
Can I update a normal monday.com column with a formula result?

Yes. Instead of only displaying a calculated value, you can write the result into a regular monday.com column.
Can I calculate totals from another board?

Yes. For example, you can calculate invoice totals, ticket counts, tracked hours, task counts, budget usage, or other values from related board data.
Can I preview formula results before updating monday.com?

Yes. Previewing is important because it lets you check calculated values before they are written back to monday.com items.
Can I bulk update several items at once?

Yes. Once the formula has been tested and the previewed values are correct, you can update several items in one workflow.
Should I use Spreadsheet Gorilla for simple same board formulas?

Usually, no. If a simple monday.com Formula Column solves the problem, that may be the simpler option. Spreadsheet Gorilla is more useful when the calculation involves multiple boards, custom formula logic, lookup style calculations, or updating target columns.

Conclusion

Create cross board formulas for monday.com

Native monday.com formulas are useful for simple board calculations. But when your data lives across several boards and you need to calculate, preview, and write results back into monday.com columns, Spreadsheet Gorilla gives you a more flexible spreadsheet style workflow. You can organize board data in reusable templates, create custom formulas, preview calculated results, and update monday.com board columns with the final values.

Explore Spreadsheet Gorilla