-
Data Shuttle - Workflows Failing
I have multiple offload and upload workflows that have functioning quite well in Smartsheet, however after a week or two they seem to randomly not be able to find the Attachment File for the upload workflow and then give me that wonderful red error message. Anyone have a solution for this issue or at least an explanation?…
-
Auto Attach Report .pdf to new source sheet row
Is it possible to take data from a Report and have it auto export as pdf/excel file and attach that new file to another sheets row? Case: We have a User Access process built and once a month, the primary owners of each software need to review the user access as a pdf file. We were using the "Send as Attachment" feature in…
-
Datamesh multiple data to single data field
Is it possible to setup a Datamesh that carries multiple data from a source sheet to a single data field in a target sheet? For example, when name in Name target = Name source carry over ALL data points from #s source to #s target and dates source to dates target such as in below screenshot. Help is much appreciated.
-
Jira - Smartsheet Connector
Hi Team, I have setup a connector between jira and Smartsheet and the data is flowing bi-directionally without any issues. However, if i delete a ticket from jira, it is not getting updated in the Smartsheet. Rather, I have to resave the entire workflow by selecting edit workflow option (where i don't make any changes) and…
-
Excel Tab Changes Impacting Data Shuttle
Hi - I have a data shuttle set up from a shared Excel file into a smartsheet that I use to basically alert me when changes are made to the excel by users other than myself. When I set up the data shuttle, the tab that I was referencing was Tab 1. Now the users have moved the tab and it is Tab 3. Do I need to update my Data…
-
Is it normal that drop-down list uploaded by Data shuttle doens't allow multi-selection ?
Hello, I just noticed this issue: I had a workflow from Data shuttle to sync a drop-down list of employees in one of my form. In this form, I have the option "mutliselect", but when I go in the field, whenever I select an additional employee, it deletes the previous one, is it a normal behaviour or a bug on my side (we are…
-
How to delete/transfer existing JIRA connector workflow which was created by EX team member
For one of my existing intake process, we have connected the same with Jira board using JIRA connector and now the connector is not working and person who created has also left organisation. I am not able to create another workflow for the same sheet as its restricted and i am not able to delete the existing workflow as…
-
Automating Invoicing
Hello, I am trying to wrap my head around how I can get smartsheet and the Generate documents function to create an invoice based on a form submitted. I was able to figure out the right balance in the form itself and how to connect the fields to populate each invoice. Where I am having issues, is each form submitted can…
-
Using IFERROR Formula - Still getting UNPARSEABLE error
I'm calculating a Burn Rate Percentage so it's using a basic calculation FORMULA =[Column4]@row / [Column2]@row --> This works fine However when one of the Column is a ZERO, I get a #DIVDE BY ZERRO error displayed. To address this error, I used an IFERROR but it's giving me an "UNPARSEABLE" error. I want the cell to…
-
Manufacturing Production Report
Hello, I work for a relatively small manufacturing company where our production managers meet every single morning, give their production numbers, headcount, etc to the manufacturing managers for them to enter the data manually in excel every morning. We created a form in Smartsheet for the production managers to enter…
