Add Ons and Integrations

Add Ons and Integrations

Ask questions about Control Center, Dynamic View, DataMesh, Pivot App, Calendar App, or WorkApps. Discuss connecting Smartsheet to your other systems with integrations such as Bridge, Data Shuttle, the Jira connector, and the Salesforce connector.

Data Shuttle filter logic

Looking for assistance on my "Add" workflow. I am uploading an excel spreadsheet that has mutliple criteria that is not relevant to my needs. I set up my filters as shown below and when I run data shuttle, my sheet is completely blank.

Answers

  • Community Champion

    A few questions and things to consider:

    —Does your input file include column headers? If so, make sure you set that up.
    —Does your workflow point to the correct tab on your input file? Doublecheck that.
    —Is your Shuttle workflow set up to Replace all target sheet rows with the data from the input file, or Merge data into the target based on a key column value? If the latter… is your target sheet blank? For some reason, this tends to present an issue for me at least. Perhaps manually add a row or two before trying to run it.

    This is by no means a comprehensive list, but will get you going down the troubleshooting path. Good luck!

    If this answer resolves your question, please help the Community by marking it as an accepted answer. I'd also be grateful for your response - "Insightful"or "Awesome" reactions are much appreciated. Thanks!

Trending Posts