Keep data across your sheets in sync with DataMesh

Eliminate manual work with DataMesh to keep your sheets and reports in sync — without manual copying and pasting or complex formulas.

Contact our team

One-to-many connections

Drive information across multiple sheets from a single source of truth (sheet or row report).

Map data — without formulas

Effortlessly create relationships between data from multiple sheets, all without formulas.

Data merging

Merge changes into Smartsheet to update existing information with the most up-to-date values.

Reference cell images & hyperlinks

With DataMesh, you can easily create cell links to pull over images in cells and hyperlinks across sheets.

With DataMesh, client services coordinators simply select a broker and the data matches automatically, with updated contact information. It eliminates the need to manually type in this data every time.

Crissy Nolen, Chief Marketing Officer, Colliers International

Read customer story

Customer stories

Cisco’s Public Sector team saves more than 80 hours per week with Smartsheet for Project & Portfolio Management

With the Smartsheet for Project & Portfolio Management (PPM) solution, the Cisco Public Sector team automates projects and processes to dramatically increase productivity and save countless staff hours

Special Olympics USA Games

The 2022 Special Olympics USA Games relies on Smartsheet to increase event visibility, easily manage a complex week-long competition, save $200,000, and integrate seamlessly with a new fan engagement mobile app.

Global distributor adopts Smartsheet for portfolio project management; gains workflow automation too

Frequently Asked Questions

DataMesh allows you to sync data between sheets and reports within Smartsheet to keep different elements in Smartsheet in sync with less manual duplication. You can designate a sheet or row report as a “source” and push rows and columns of information from this source to one or many sheet “targets” throughout Smartsheet.

Data Shuttle is a tool that can be used to import or export CSV or XLSX files from external systems into Smartsheet. DataMesh can similarly sync data between two locations but instead of connecting between an external dataset and Smartsheet (the purpose of Data Shuttle), it can be used to merge and sync data between two different sources (such as a sheet) within Smartsheet.

Formulas like VLOOKUP and INDEX/MATCH work similarly but with the differences that DataMesh does not require the building of formulas, can be used to add new rows to your sheet, and can sync more complex cell information, such as hyperlinks and images in a cell.

DataMesh is recommended when you would like to link common datasets between sheets.

Yes, DataMesh is a paid premium offering. It is included in Smartsheet Advance. For information about pricing, please contact our team.

If DataMesh is available on your account, you can access it by logging in at datamesh.smartsheet.com (or datamesh.smartsheet.eu for the Commercial EU environment). System Administrators may further restrict access to DataMesh and other premium apps in the User Admin Center.

DataMesh is available in the Commercial Smartsheet and Smartsheet Regions EU instance. It is not currently available in Smartsheet Gov. Check out our comparison articles to learn more about differences between Commercial Smartsheet and Smartsheet Gov or Smartsheet Regions.

You can learn more about DataMesh in our Help Center Learning Track.