Applies to
DataMesh FAQs
Find answers to the most frequent questions we get about DataMesh.
Who can use this?
Plans:
- Smartsheet Advance Package
What permission levels do you need for Data Mesh?
To use DataMesh, you must
- Have Viewer permissions or higher on any source sheet and Editor permissions or higher on any target sheet
- Have DataMesh application permissions enabled in Admin Center by a Smartsheet System Admin
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 plan, who can use it?
Any user has access to creating workflows by logging in at datamesh.smartsheet.com if DataMesh is available on your plan.
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 service 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.
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.