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 Shuffle Errors

I have a daily data shuttle that brings in data from a Pivot Table via Excel. I have attached a screen snip of my filters. It does not bring over any credit values (Example: -$200.00) and I need it to for accurate reporting. Please advise on how to correct my filters so all applicable data shuffles in.

Data Shuttle Filters.PNG


Answers

  • Community Champion

    Hello @Calderon93

    From what you have shown, the only recommendation I can think of is removing the filters entirely.

    Otherwise you can try adding another value to specify whether the amount is credit, in the source file. Then add that as a new filter. Although that would be counterintuitive because you're already filtering out everything that's on credit by requiring the value to be greater than 0.

  • I will try that. Thank you for the assistance!

Trending Posts