Product questions?
Ask it here! The community's got your back.
Discussion List
Data Shuttle not updating with all data
I have created a Data Shuttle upload, with no filters, to replace rows on my Smartsheet destination sheet. I discovered that all rows were not being added to the destination sheet. Debugging narrowed the problem down to the contents of one column. In Smartsheet, the column is formatted as Text/Number. In Excel for testing,…
Document Builder and Automation
Is there a way to generate a specific PDF using automation based on specific criteria? I have 3 documents that would need to be used depending on the department that uses them. Can this be done using automation using conditions?
Jira Connector
Is there a way on the Jira Connector Manual Workflow to schedule it run the same time every day?
Data Shuttle importing Values
When I use Data Shuttle to import data to a sheet, it keeps adding a ' in front of the numbers which turns them into text and not numbers. For example, $23.50 turns into '23.50 when imported through Data Shuttle. The original excel file itself is formatted correctly. Anyone know how to fix this?
Merged: DataShuttle Workflow Errors (Action:Replace)
This discussion has been merged.
Merged: Data shuttle not functioning correctly?
This discussion has been merged.
Data Mesh Config Not Updating When New Fields Added from Source Report
Hi -- I set up a data mesh initially with 6 fields from the source report. Then I decided to edit the config and add more fields to bring it, but it won't let me add them to the target sheet because they don't appear in that dropdown.
Is there any way to get good data from multi-select columns/cells in Pivot?
I've been working to use Pivot & Data Mesh to replace most, if not all, of my complex "summary sheets" where I have tons of cross-referencing formulas to pluck and calculate all the information I need from source sheets to trend KPIs. I love that pivot tables are dynamic, and update at my chosen cadence. For example, it…
Look-up Field and Database-Like Display
Does anybody know if it's possible, and if so which add on products you need, to create a front facing user site that has a place to basically input or select a value, and then view data dynamically being pulled from a source sheet for just that value? The use case is that we have a lot of properties, so wanting to create…
Is it Possible to Duplicate Row and it's Sub Rows - Linking Data
Hello! I'm new to using SmartSheet, and I recently downloaded the Payroll Register Template. I'm curious if there's a way to duplicate a row along with all its sub-rows, and if so, could you provide guidance on how to achieve this?? Also wondering if there's a method to link it to a separate sheet where I've compiled a…