-
DataTable used for a Datashuttle Workflow
Hi, I attempted to use an upload workflow (Datashuttle) for a sheet connected to DataTable, but the data did not populate. Is this a limitation within Smartsheet?
-
Dynamic contact list using reference sheets and Data Shuttle
I have several sheets (>20) that utilize a contact field for which I need to update the options whenever there are changes to our roster. I have difficult contact fields depending on someone's role in the department. My solution, based on suggestions here, is using a regular dropdown as my "contact" field that users…
-
How can i create a data shuttle workflow to only offload new rows.
I only want new rows to be offloaded. Is there a way to set up my data shuttle filter to only offload those rows that were entered since the previous workflow run?
-
dynamic view access for more than one contact column
Hello- I have a dynamic view i'm trying to share with anyone in the manager 1, manager 2, or manager 3 columns. so far- i've only been able to select one column at a time for access. is there a way around this i might be missing? ideally i'd like just one view where you can see rows if you're in one or all of these 3…
-
Automate a sql query of public information to merge with Smartsheet
Hello! I'm seeking steer on an automation. I am manually mining publicly available data (ClinicalTrials.gov) using a query of this database - https://aact.ctti-clinicaltrials.org/ - and I merge the results into my sheet via a data shuttle upon attachment to the sheet. At present, I do this about once a month (or whenever I…
-
hyperlinking to a folder and or file on our local network drive
I would like to hyperlink a folder to our company shared drive from smartsheet. I keep getting the error message "Invalid URL" I have seen from other comments that this is an issue, is this some feature that may be added by smartsheet? It would greatly benefit the way we could use smartsheets. Thanks for your anticipated…
-
How do you avoid Power BI Semantic Model Error when column headers are modified (add/remove/edit)
For anyone connecting Smartsheet with Power BI and using sheets as sematic model, and set a scheduled refresh, you might have encountered errors where when a column has been modified, whether add or removed or renamed, the refresh is halted until. My usual fix is to download the PBIX and update source (Navigation) to…
-
Dynamic View Document Download not working in Chrome
Is anyone else having trouble downloading documents from Dynamic View using Chrome? They have been working just fine until yesterday. They are still working in Edge, but nothing in Chrome.
-
Bridge: Stuck! GET /users/{{inputs.userId}} Child Flow not running
I can't get my child CHILD WORKFLOW B (See Below) workflow to run. I've been on ChatGPT all day and it keeps making me run in circles. It works GREAT up until Child workflow B. there is nothing in the run log showing why :( WHAT I'M TRYING TO ACCOMPLISH: Should be fairly simple, right? Not for me. :) This Parent workflow…
-
Using Data Shuttle to check for duplicate values
I am trying to have data shuttle check if something on the target sheet already exists on the file I am using in Data Shuttle. For example, my target sheet has UPC, UOM, Vendor Name and Vendor Part number. I want to have it check the file I load into Data shuttle and return the Internal Part number if it matches those 4…
