FAQs

To use DataMesh, you must: 

• Have Viewer permissions or higher on any source sheet, and Editor permissions or higher on any target sheet.
• Have the DataMesh application permissions enabled in the Admin Center by a Smartsheet System Admin.

Yes, DataMesh is a paid premium offering. Learn more about the features and benefits here. For information about pricing, contact our sales team.

DataMesh is available in Commercial Smartsheet and Smartsheet Regions. It isn't available in Smartsheet Gov.

Check out our comparison articles to learn more about the differences between Commercial Smartsheet and Smartsheet Gov or Smartsheet Regions.

Any user has access to creating workflows by logging in at datamesh.smartsheet.com if DataMesh is available on your plan.

DataMesh appears in the launcher until a user logs in at datamesh.smartsheet.com for the first time. System Admins can further restrict access to DataMesh and other premium apps in the User Admin Center. 

VLOOKUP and INDEX/MATCH can be used to create linked values through formula lookups between two sheets. This contributes to the cell link limits within Smartsheet and sheet performance.

DataMesh, on the other hand, doesn't require formula building, and the Copy Data and Copy and Add Data options don't contribute to a sheet's cell link limits. 

Copy and Add Data can also be used to add new values to another sheet in Smartsheet, which can't be achieved with VLOOKUP or INDEX/MATCH.

• Smartsheet Support

• Smartsheet University Training*

• Pro Desk*

*These resources are dependent on your plan support type.

All Smartsheet limitations still apply when working with DataMesh. Sheets today can support 20,000 rows and 400 Columns (DataMesh can support up to 190 mapped columns). Any given sheet supports a maximum of 500,000 cells, and each cell supports a maximum of 4,000 characters. 

If you would like to create a DataMesh from a dataset with more than 20,000 rows, consider DataTable, which supports up to 2 million rows.

Yes, columns need to be remapped if they are renamed. 

You can use a row report, but not a sheet summary report, as a source. It’ll allow you to select the sheet summary as a source, but you won’t be able to map the fields, and the workflow configuration will show the error: Something went wrong. Please try again later. If the issue persists, you can contact support. 

Yes, this is a self-service option for the workflow owner, but they must ensure that the new owner has Admin-level sharing permission or higher on both the source and target sheets. 

Yes, log a support ticket with the details of the user(s) you want to transfer from and to. The target user needs to have logged into DataMesh and have Admin access to the source and target sheets used by the configs. 

No, you’ll need to create a new workflow if you want to change the source or destination sheets. 

While the workflow builder doesn’t offer a filter option, you can use a report instead of a sheet as the source. Add filters to your row report to sync only specific rows. Be sure to add all the columns you need in the report as well. 

Since DataMesh is a web app, it uses your computer time, not your Smartsheet account time. 

If a user's sheet access is removed or downgraded below the required level, the DataMesh configs they own will stop working. However, the configs will continue to work as long as the user retains the appropriate sheet access and their user ID remains valid.