-
Data Shuttle Merge
Hello. I have a data shuttle set up to merge changes into a grid. I have a column that is called ID in both that is the same, but when I run it no changes are made. I have added fake changes to ensure something would happen but still nothing. My thought is maybe since the ID is a concatenation of other cells in both the…
-
What does the popup mean in Dynamic View?
I am currently get this when trying to access a Dynamic View. The owner has recently left the company and not sure what was done with the views he created as far as ownership. I have admin access but can't seem to access the view either.
-
Copy row automation isnt working from DataMesh sheet
Hi - I have a sheet setup through DataMesh that links 10 columns from my source sheet. Then, I setup an automation to copy rows from the DataMesh sheet to other Smartsheets. However, the copy rows automation only works when I hit "run now" - it does not run when when triggered. My objective is to use the DataMesh sheet so…
-
ServiceNow and Smartsheet BRIDGE integration
Hi, I am trying to bring all records from a table in ServiceNow into my Smartsheet. All field names align and I am able to get the record from ServiceNow but unable to send that data into an existing Smartsheet. I did get it to add one row from ServiceNow but that's only if I reference the row specifically in the Key and…
-
Data Shuttle Error
Hi All, I am hoping someone can help me with this data shuttle error: Workflow Execute: Your workflow maps columns that no longer exist. Please refresh your mapping to remove the deleted columns. While normally I would go in and refresh the columns, and it would be fine, this time I am copying all of the columns verbatim,…
-
Data Shuttle - workflow & row options
Hello, I am trying to set up a workflow to bring in employee data based on certain filters. Once those employees are in the sheet, I need to keep certain fields updated as they change plus remove employees that no longer meet my filter criteria. What workflow actions and row options would I select? (I have all the columns…
-
Is there a way to display URL links in the calendar app?
I have a column in a report that has links to URLs that relate to the Events in my calendar that I have created in the app. Is there a way to get them to display as a link in the calendar like they do in the report? Or is there another way you recommend I show these links? Thank you!
-
Data Table: Automatically Updating Source and Target Sheets
Hi all! Coming to the experts for this… My company has 20k+ employees, so I cannot have all their employee information on one sheet. Instead, I've broken it up into two different sheets: one for executives; and one for non-executives. I'll refer to these as the "main sheets." I also have different sheets for each of our…
-
Cell Linking Multiple Cells with Control Center
I have two items that are provisioned in Control Center when a user submits a new project - one is a checklist and one is the project team list. In the checklist, the role for each task is linked to the team list (so a person can be marked the Project Manager in the team list and all applicable tasks in the checklist will…
-
Bridge: When a cell in a parent row is updated, update the same cell/column in child rows
Hi there! I think what I need to do is search the sheet for all rows whose parent IDs are equal to the row ID of the row that triggered the workflow. Once I am able to grab those rows, I know how to have Bridge update them. :-) I am stuck trying to figure out how to include the "parent.Id" data in a sheet search in order…
