-
Using DataMesh to Split One Line Onto Multiple Lines (for Forms Entries and Other Uses)
This is a problem I've heard a few times so I'm answering it in a separate post for reference in long form. I'm using the example from @WtaylorW's question over here. The basic need is to take one line and split it onto multiple lines. In this example you have a form that's inputting multiple names in different columns,…
-
Bi-directional update between 2 sheets without report?
Hi, is there any workaround that allows for bi-directional updates between two sheets without the use of a report? For example, Sheet 1 has Unique ID and Status columns, same goes for Sheet 2. What I want to be able to do is if either the Status column gets updated for a project in Sheet 1 or Sheet 2, the information will…
-
Data Mesh. How to pull multiple data points based on multiple selections into one cell
Hi Everyone, I'm looking into setting up a small process that would allow my team to essentially select multiple choices from a drop down in-order to combine the various results that those selections represent in a separate sheet. The key is that we want to combine those options in a single cell. Does anyone know if this…
-
DataMesh Config : Duplicate Values in Source Sheet
I am looking for a solution/workaround for DataMesh not only to return the 1st Match currently set up in the config settings: "Duplicates in Source Sheet", but also any match that follows. I have the source sheet in which entries are fed via Form and I have set an automation "Copy to Another Sheet" when a certain criteria…
-
DataShuttle, DataMesh, Something Different--what's best
There is an excel report we get from another system that needs to be brought into SmartSheet on a weekly cadence. It is a timeline-driven document so we need the updates on dates, status, and new entries (rows) to be brought into SmartSheet. The report has this information for four teams, so we need the information from…
-
Data Mesh: Source report becomes "Not Found" after it's selected during Config creation
This is happening across multiple browsers and accounts, but just for one particular report. I can't use it in a data mesh and I'm seeing the message "Something went wrong. Please try again later." I go to New Config - Select Source sheet - and the report I want is visible, but then one of two things will happen: A. I…
-
Data Mesh Multi-Column Match
I think it would be beneficial to have a multi-line match option within a data mesh instead of having to setup 2 different configurations. For example, attempting to match the values in two columns to meet the criteria to proceed would help if you happen to have a few duplicates in one of your columns, then the secondary…
-
Enable sheet summary reports to be used in Data Mesh
Currently, reports generated using Sheet Summaries return an error message when attempting to use them in a data mesh configuration.
-
Datamesh to edit a column with a Formula
hello i d like to consolidate in a sheet data coming from 2 different sheets Target sheet contains columns with Formula, and i d like to add automaticcally rows to that target sheet by using Datamesh. Columns are in same format it seems that datamesh can't create rows if one of the column has a formula. can you confirm ?…
-
DataMesh - Always add a new row
I'm trying to use datamesh where I want it to always add a new line to the target sheet, even if the Lookup Value is a duplicate. When I add a new line to the source sheet, if the lookup value is unique, it will successfully copy over to the target, but if it is a duplicate, it doesn't do anything. How could I achieve this?
