Product questions?
Ask it here! The community's got your back.
Discussion List
Data Shuttle
I am using data shuttle to upload a large spreadsheet to Smartsheet. The data shuttle program quit recognizing the first cell in my spreadsheet and I cannot determine why. I have tried changing this cell to both a text format and a number format and it still does not recognize the cell. I have remapped and refreshed…
Can Requested Data be Compared Against Product Available Data
I have a situation where a form request for products populates a sheet but the products requested may not be available in that market so the request is an invalid one. It would be great if, after form submission, we could compare the new row (request) against a matrix sheet of available products. Has anyone done that…
SmartSheet Dashboard: Enter a value, have data autofill
Is there a way to build a SmartSheet Dashboard, and have a field that we can enter a value (say a project #) and have the corresponding fields autofill/populate as a result of that action? Or have a dropdown that autofills with all of the project #'s, we select one and then the corresponding fields populate from that…
How to write to smartsheet without python?
We user Alteryx to read from smartsheet using the live data connector. We also need to write to smartsheet from Alteryx. I've seen people do this in Python, but I don't know python. Does anyone have anything canned/pre-written using an ODBC connection and not an API/python?
Will a new Smartsheet saved with the name of a Source Sheet still work with DataMesh?
Looking to save some time by replacing old information within a Source Sheet with information housed within another Smartsheet. Can I relabel the original source sheet to an obsolete name and save the new Smartsheet with the source sheet's name and keep all the connections working with DataMesh?
Error: Column 5774417348847492 no longer exists in the source sheet.
I'm using document generation, I get this error. I'm unsure what column this is referring to.
Trigger acknowledgement on form submission
I want to call a Smartsheet form from another program and have the Smartsheet form send an acknowledgement to that program when the form is submitted
Grouped Filters in DataShuttle
The ability to use grouped filters in DataShuttle would significantly increase the flexibility and usability of the import dialogue. Example: (1 AND 2) OR (3 AND 4). This would allow for more criteria to be added to the import filter to get more targeted data added to a sheet.
Integrating Reports
Hello, I need help on an integration project, but I need assistance on how to create the sheet to complete the job.
How to copy newly added rows in a Source Sheet to a Target Sheet without copying Source columns?
Hi there! I have a DataMesh that is set up between two sheets. When I add a new row to the Source Sheet, I would like for the DataMesh to pick up that new row and bring it into the Target Sheet, however, it does not seem capable of doing that. The other method which I have explored is the Copy Row Automation -- this works…
