-
Clear a Sheet on a Schedule
Hello lovely community, I need some help figuring out the best mechanism for clearing a sheet on a schedule. It really should be easier than this! I have tried the following methods, and outlined the limitations and issues below. I would LOVE to get some suggestions for other methods! Problem: I need to fully clear (delete…
-
How is an existing DataMesh configuration edited to add more target sheets?
What are the steps or are the no steps to add more sheets to Step 2 - Select Target Sheet(s) for an existing configuration. I've clicked the gear, clicked previous but cannot get back to the Step 2 to add more target sheets. Help please or is this not an option for this feature? Thank you!
-
Can DataMesh pull in data that is not matched?
Hi, I was wondering if there is a way for DataMesh to pull in data that is specifically not matched instead of matched? What I'm trying to do is pull in a list of newly created projects in Talkwalker by using DataMesh to compare our current project list in Smartsheet with an Excel sheet of projects exported from…
-
Data Mesh Target sheet re-creates rows that have been deleted on target and source
Deleted 5 rows from the Source sheet. Then deleted those same rows from the target sheet. The same 5 rows keep getting re-populated on the target sheet, but only the lookup values. I assume it is because I have "copy and add data" as the data mapping format in the Data Mesh settings, but that is the correct setting for my…
-
Report of all connected integrations affecting the sheet
Had a situation where two different admins had DataMesh running to a target sheet. As you can't see someone else's configs, it was difficult to figure out what was going on. Some kind of report that could be pulled by an Admin from the add-on that shows a list of connected items.
-
Datamesh - update mapping table without logoff
Currently when working on a datamesh and a change is made to either the source or target sheets I am unable to refresh the open job and make my necessary mappings. Instead I have to save the incomplete job, close the browser and log back into Datamesh to see the sheet changes. Would like to be able to to refresh to get the…
-
Change the source sheet Data Mesh?
Hi, is it possible to change the source sheet in Data Mesh? Or do I have to create a new Data Mesh? Thank you
-
What are the Data Mesh Cell limitations
Hi, I know when I run Data Mesh there are limitation to how many cells can be updated but I don't remember how many cells are allowed. Does anyone know? Thanks Kim
-
Sheet API Info
Something you can reference on a sheet to see what APIs are attached and who the owner of the API is. Pivot, DataMesh, DynamicView, WorkApp, etc. You need a method to ensure you don't break something but you have to know what could be broken first. Related to the Sheet Statistics request.
-
Data Mesh Adding Data to column without overwrite?
Hi, I have a base information sheet with a comment section. In another new information sheet that people will add new rows with a comment column. When Data Mesh runs I want the new comment to be added to the current comment already in the base information and not overwrite it. Is that possible? To add information to the…