How to utilize Google Sheets formula capabilities on monday.com boards

Use case overview

With resynced.io, you can bypass the limitations of monday.com’s Formula column, such as the inability to put any integrations or automations on top of it. Sync data from a monday.com board to Google Sheets, run calculations, and send the results back to update your board—all in one setup.

Prepare your data

In monday.com
Create a board with the necessary columns and data. Add a new number column to store the calculated results from Google Sheets.
In Google Sheets
Create a Google Sheets file with matching column headers.

Connect your accounts

If you haven’t already, authorize your monday.com and Google Sheets accounts to connect them with resynced.io. For details, see the monday.com and Google Sheets integration pages.

Set up the synchronization

In resynced.io, select monday.com and Google Sheets as the apps to sync. Choose the workspace and board from monday.com and the spreadsheet and sheet from Google Sheets.

Match your data

In the “match by” section, select a field that contains unique values to match data between the apps. This is like a unique ID that helps the system know which items in monday.com correspond to the rows in Google Sheets. Every value in this field needs to be unique. If two items have the same value, synchronization will not run, but your data will not corrupt. The system will notify you and show you where the problem is.

Enable item creation or deletion

By default, item creation and deletion are turned off. You can enable resynced.io to:
· Create new items in one app when they are added to the other.
· Delete items in one app when they are removed from the other.

Map your fields

In the “Synchronize” section, match fields in monday.com with corresponding columns in Google Sheets.
Set the sync direction:
· Source data flows from monday.com to Google Sheets for input values.
· Calculated results flow from Google Sheets back to monday.com.

Sync Timing

Synchronization occurs in two cycles:
· Sync input data from monday.com to Google Sheets.
· Sync calculated results back from Google Sheets to monday.com.
Synchronization runs automatically every 10 minutes, but you can start it manually to test your setup immediately.

Run the first synchronization

Click “Save and Run” to send input data from monday.com to Google Sheets.

Add Formulas in Google Sheets

Set up formulas in Google Sheets to calculate the results you need using the data synced from monday.com.
Make sure the formula is copied to all rows so every item is calculated correctly.

Run the second synchronization

After adding formulas, run synchronization manually to sync the calculated data back to monday.com.
For a detailed, step-by-step guide, check out the Quick Start guide.
An example of setup is provided below.

Similar guides