Applies to
Capabilities
Who can use this capability
To use DataMesh, you must
Be a Licensed User
Have Viewer permissions or higher on any source sheet and Editor permissions or higher on any target sheet
Have DataMesh Application permissions enabled in User Management by a Smartsheet System Admin
DataMesh FAQs
Find answers to the most frequent questions we get about DataMesh.
Is there an additional cost for DataMesh?
Yes, DataMesh is a paid premium offering. Learn more about the features and benefits here. For information about pricing, contact our sales team.
Is DataMesh available for Smartsheet Gov or Smartsheet Regions EU?
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.
When I have DataMesh purchased on my account, who can use it?
If DataMesh is available on your account, by default any licensed user has access to creating workflows by logging in at datamesh.smartsheet.com.
DataMesh shows up in the launcher until a user logs in at datamesh.smartsheet.com for the first time. System Administrators can further restrict access to DataMesh and other premium apps in the User Admin Center.
What is the difference between using a VLOOKUP or INDEX/MATCH formula and DataMesh?
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 the building of formulas, and the Copy Data and Copy and Add Data options don't contribute to the cell link limits on a sheet.
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.
When I need help, what are my support resources?
Smartsheet University Training*
*These resources are dependent on your plan support type.
What are known limitations of DataMesh?
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 mesh from a dataset that exceeds 20,000 rows, consider DataTable, as this supports up to 2 million rows.
If columns are renamed after workflow configuration is set up, will the columns need to be remapped?
Yes, columns will need to be remapped if they are renamed.
Can you use a report as a source?
You can use a row report but not a sheet summary report as a source. It will allow you to select the sheet summary as a source, but you will not be able to map the fields and the workflow config will show the error: Something went wrong. Please try again later. If the issue persists, you can contact support.
Can individuals transfer DataMesh workflows?
Yes, this is a self services 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 sheet.
- A license on your Smartsheet plan and has DataMesh access toggled to on in the Admin Center.
Can you bulk transfer ownership of DataMesh configs for an org?
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.
Can you change the source or destination sheets once a workflow has been created?
No, a new workflow will need to be created if you want to change the source or destination sheets.
Can I add filters to narrow down what should be pulled from one sheet to the next?
While there is no filter option in the workflow builder, you can use a report as the source instead of a sheet. Add filters to your row report to only sync specific rows. just be sure to add in all the columns you need in the report as well.
How can I update the timezone shown in DataMesh?
Since DataMesh is a webapp, it uses your computer time, not your Smartsheet account time.