-
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…
-
Importing Dates
I am importing a manufacturer's shipping report into Smartsheet with Data Shuttle. If the product has not shipped, the manufacture has a date of 00/00/0000. When I import the data, I want the date to be blank, if the date equals 00/00/0000. How can I make the cell blank if it the date imported is 00/00/0000 ??
-
Ran workflow - sheet remains blank, data not pulled from most recent attachment
I am trying to create a workflow that will merge data/adds rows when a new file is attached but every time I run the workflow, the sheet remains blank. After I attached the file, I deleted the data to ensure the workflow was working properly. See the steps I followed below. I have tried both options listed for 'source…
-
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.
-
Data Shuttle Run Report
Hello, I have some Data Shuttle runs that I'd like to have report out to a dashboard so I'm aware of how many new rows are added and updated each day. Is there any way to display this data outside of Datashuttle?
-
Data Shuttle input not working at all-source field not mapped
Hi guys I have tried 50 times different scenarios and just can not get it to work. I'm trying to set up upload data , using 2 exactly same file one in my sharepoint personal folder second is the smartsheet , no matter what i do i always get source field not mapped and can not select anything else. I have tried to output…
-
Trigger Data Shuttle to run with the API
Can't schedule a data shuttle monthly, so maybe if we could trigger a workflow run via the API that would solve that problem.
-
Data Shuttle Synch Capability
Hello - I need to set up a sheet based on an employee roster that will be updated quarterly. I'd like to use a Data Shuttle upload workflow to attach the updated roster to the sheet and have it automatically remove termed employees and add new rows for those that are new hires, without deleting the existing rows in the…
-
Unable to disable DataTable connections to sheets. Has anyone encountered this?
I have not had any issues in the past with disabling the connections. I have 30 sheets with connections, when I disable the connections they show disabled but after a few minutes they become active on there own. The sheets have many connections to them via formulas (index/match) and smartsheet apps (dynamic view, data…