How do I use formulas across monday.com boards to update board columns?
Are you looking for a way to perform cross-board calculations on monday.com to update board columns? In this guide, we'll explore how to build advanced formulas and cast their results to board items.

Table of contents
Use the navigation to quickly jump to your desired section and learn more about the pros and cons for each option or head straight to the conclusion.
Introduction
Why you would consider calculating formulas across monday.com boards to cast their results into a column of another board
Before we deep dive into all the available options, let's take a quick look at potential use cases why you would want to make use of advanced cross-board formulas to calculate data with Excel-like functions that can be casted into another monday.com board column. You can learn more about real-world use cases from monday.com users in this forum thread about cross-board formula implementation, which has more than 70 upvotes at this point.
- Formulate in one board from another boards column and cast the result to a third board
- Manage budget related queries and timely payments for projects across boards
- Cross-reference a board with a schedule to associate someone with a time stamp
- Cross-query a board by a tag and do a sum of the completed time within a timeframe
- Reference another board and filter by task in order to populate the date on the main board
- Sum the total work remaining for each person from one board and cast it to another board
- Gather project invoices in one board, sum the totals and cast the sum to a main board
Option A
How to perform cross-board calculations with monday.com's native Formula, Connected board and Mirror columns
This option is viable if you simply want to use and include connected items and mirrored columns in formula columns. You can learn more in the monday knowledge base about the Mirror Column, Connect Boards Column, and the Formula Column. Though by choosing this method, you are unable to reference columns from different boards within that formula, without having to use mirror and connect boards columns. And since mirroring means you only have one single source board that is "sending" the monday.com board column data to the destination board, this option lacks flexibility for many advanced use cases.
Pros
- Automated processing
- Available across all plans
- Viable for simple use cases
Cons
- Lack of flexibility when many boards are involved
- Floods boards with many connected and mirror columns
- Lack of cross-workspace board formula calculations
- Limited functions to perform advanced Excel-like formulas
Option B
How to calculate and cast formula results across different monday.com boards with Spreadsheet Gorilla for monday.com
This option also includes the use of monday.com's connected board columns for referencing items across different boards. But it denies the mass usage of multiple mirror and formula columns on your main monday.com board. All the magic is relocated to the so called Spreadsheet Templates. These templates are basically an abstraction layer of your monday.com boards, where you choose and combine all the boards which need to be used for calculations. Furthermore templates are used to map board columns to "headless" or "virtual" spreadsheet columns across Excel-like worksheets. Head over to the tutorial video down below to get a quick overview of the apps' capabilities.
Pros
- Complex calculations across boards and workspaces
- Single board item updates or in bulk with preview
- Create and perform formulas like in Excel
- More than 200 Excel-like functions
Cons
- Semi-automated process
- Additional monthly or yearly costs
Tutorial
Learn how to use Excel-like formulas across multiple monday.com boards and update board items in another board
The following video tutorial covers one quite simple use case that basically assumes that your team gathers invoices from different projects in one board, and you want to add up the total amounts of those invoices, to finally cast that sum into another board for having an overview of all budgets left for each project. Feel free to book a demo, to discuss your individual use case and see if Spreadsheet Gorilla for monday.com is a fit.
Conclusion
What is the best way to create advanced formulas across different monday.com boards and update related board columns with their results
In conclusion, incorporating cross-board calculations into your monday.com workflow offers a multitude of benefits, from managing budgets to streamlining project updates across multiple boards. While monday.com provides native options such as Formula, Connected Board, and Mirror columns, they may lack the flexibility needed for advanced scenarios. However, tools like Spreadsheet Gorilla for monday.com offer a comprehensive solution, allowing complex calculations and seamless updates across boards and workspaces akin to Excel-like functions. Though there are additional costs involved, the efficiency and capabilities provided make it a valuable investment for optimizing your monday.com workflow and enhancing collaboration across teams.
Discover our tutorials, guides and
new updates for monday.com
- All
- Client Portal Builder
- Board to Website Widget
- Spreadsheet Gorilla
- Exported Excel Cleaner
What’s new on monday.com? Feature update in October 2025
Here’s what’s new on monday.com in October 2025. This month’s updates center on smarter forms, recovery options, deeper search, and new sprint workflow triggers. Learn more about each new feature.
Set up and use Google Auth in Client Portal Builder for monday.com
Want to allow your clients to sign in to your client portal with Google Authentication? This guide covers everything you need to know about how to set up and use Google Auth with your client portal.
Embed monday.com boards into Squarespace, Wix, WordPress or Webflow
In this guide, you learn how to seamlessly embed monday.com boards as fully branded and synced website widgets into your website made with Squarespace, Wix, WordPress or Webflow.
What’s new on monday.com? Feature update in September 2025
If you're using monday.com, you’ll want to know about the recent enhancements rolling out this fall. From smarter AI suggestions to new service capabilities, here’s what’s new in September 2025.
Create workflows to automate everything in your client portal
Want to automate everything in your monday.com client portal? This guide covers everything you need to know about how to create automation workflows with the Client Portal Builder.
Does monday.com have a Client Portal? Here’s how to build one.
The short answer is not natively. But with the right setup, you can create a secure monday.com client portal. In this post, we will explore built-in options, all their limitations, and how to build one.
What’s new on monday.com? Feature update in August 2025
Here’s what monday.com introduced in August 2025. These updates focus on smoother navigation, deeper AI integration, and smarter CRM task sequencing. Read the breakdown of what’s new.
Let your clients edit specific board items right in their client portal
Want to let your clients easily edit specific board items in their client portal? This guide covers everything you need to know about how to enable and make item editing a breeze for your clients.
What’s new on monday.com? Feature update in July 2025
Here’s what monday.com introduced in July 2025. This month’s enhancements center on AI evolution, platform consistency, and deeper integrations. Below is a breakdown of all new updates.
Semiannual feature recap from Gorilla Apps in June 2025
Client Portal Builder added conditional pages and sections, item commenting with automations, new Google login options, and a refreshed UI with draft management and performance boosts.
Client Portal Builder vs Softr: Which fits into your monday.com workflow?
Curious about the difference between Client Portal Builder and Softr for building monday.com client portals? This post breaks down the pros, cons, and what makes each one a better fit.
What’s new on monday.com? Feature update in June 2025
Here’s what monday.com rolled out in June 2025. This month’s updates focus on faster form creation, easier reporting, and stronger control for enterprise teams. Read more about the new features from June.
Chat and share files with clients on board items in your Client Portal
Want to easily chat and share files with clients in your client portal? This guide covers everything you need to know about how to configure and make use of item comments in your client portal.
What’s new on monday.com? Feature update in May 2025
Here’s what monday.com rolled out in May 2025. This month’s enhancements center on clearer hierarchy, smoother scheduling, better integration between docs and boards, and stronger consistency control.
Show content sections and pages conditionally in your client portal
Want to display portal content and pages conditionally and only to specific clients in your client portal? This guide covers everything you need to know about managing conditions.
What’s new on monday.com? Feature update in April 2025
Here’s what monday.com rolled out in April 2025. This month’s changes focus on personalization, smarter canvas tools, workflow enhancements, and a much deeper AI flexibility.
Let your clients trigger monday.com automations from your client portal
Want to let your clients trigger predefined monday.com automations on board items in your client portal? This guide covers everything you need to know about managing action buttons.
What’s new on monday.com? Feature update in March 2025
Here’s what’s new on monday.com in March 2025. This month’s updates bring deeper form flexibility, more control over item identifiers, personalization in board views, and visibility into API usage.
Format text sections with Markdown in the Client Portal Builder
Want to format text in your client portal on monday.com to your needs? This guide covers everything you need to know about how to make use of the Markdown syntax to shape your text.
What’s new on monday.com? Feature update in February 2025
Here’s what’s new on monday.com in February 2025. This month focuses on navigation clarity, personalization in the app marketplace, more powerful workflow logic, and smarter AI behavior.
Embed monday.com WorkForms into the Client Portal Builder
Want to embed monday.com WorkForms in your client portal on monday.com? This guide covers everything you need to know about how to embed and display WorkForms in your client portal.
What’s new on monday.com? Feature update in January 2025
Here’s what’s new on monday.com in January 2025. This month’s updates hone usability, security, and AI ties. Especially in WorkForms, canvas views, column logic, and permissions.
Semiannual feature recap from Gorilla Apps in December 2024
Client Portal Builder gained custom domains, multi-region hosting, subitem support and markdown callouts. Spreadsheet Gorilla introduced group filters and quick actions.
Connect a custom domain to your Client Portal on monday.com
Want to connect your company domain to your client portal built on monday.com? This guide covers everything you need to know about how to configure and connect a domain to your portal.
Display monday.com board items in your Client Portal to your clients
Want to give access and display select monday.com board items to your clients in your client portal? This guide covers everything you need to know about how to create and manage board sources.
Getting started with the Client Portal Builder for monday.com
Want to build a Client Portal on top of your monday.com boards? This guide covers everything you need to know about how getting started building your Client Portal directly on monday.com
What’s new on monday.com? Feature update in October 2024
Here’s what’s new on monday.com in October 2024. This month’s releases bring more flexible views, smarter AI data extraction, upgraded workflow depth, and refined notification settings.
How do I create digital product catalogs from monday.com board items?
Are you looking for a way to create a digital product catalog from a monday.com board? In this guide, we'll explore how to create a product catalog that can be seamlessly embedded into a website.
What’s new on monday.com? Feature update in August 2024
Here’s a look at the features monday.com released in August 2024. This month’s updates improve date logic, form flexibility, invitation workflows, and integration permissions.
Semiannual feature recap from Gorilla Apps in June 2024
We introduced Dynamic Boards, easier automation setup, and faster board appending in Spreadsheet Gorilla, while laying the groundwork for our next monay.com app: Client Portal Builder.
How do I export and email Excel spreadsheets on monday.com?
Are you looking for a way to send emails with attached Excel spreadsheets through monday.com automations? In this guide, we'll explore how to recurrently email Excel reports based on monday.com boards.
How do I make use of Spreadsheet Gorilla for monday.com?
Spreadsheet Gorilla is a powerful tool for everything spreadsheets on monday.com and beyond. In this guide we will explore all the apps' features like exporting to Excel, and how you can utilize them.
How do I embed a monday.com board on my own website?
Are you looking for ways to embed your monday.com boards directly into your website? In this guide, we'll explore all the options of embedding a monday.com board seamlessly into websites.
How do I remove the monday.com branding from Excel exports?
Are you looking for a solution to clean up Excel exports from monday.com? In this guide, we'll discover all options on how to remove the monday.com logo and the default formatting from Excel files.
What is monday.com and why is it so popular across many industries?
Are you looking for a comprehensive guide of why you should use monday.com for your business? In this guide we will quickly spotlight the key features of monday.com and why it's the most flexible business tool.
How do I use formulas across monday.com boards to update board columns?
Are you looking for a way to perform cross-board calculations on monday.com to update board columns? In this guide, we'll explore how to build advanced formulas and cast their results to board items.
Interested in a product demo?
Let's learn about your requirements, answer questions, and
review ways how we can help you and your organization with
our monday.com apps and solutions.