-
Data Shuttle: Will workflow run if file is attached via form?
Hello! Happy Friday! 😀 I am currently working on creating a Supply Request Tracker that will allow the requestor to upload their excel file with the list of needed supplies to a Smartsheet form connected to the tracker. The tracker will then use Data Shuttle to pull over the quantity, description, and item number of each…
-
Data Shuttle not populating my PDFs
When I upload my excel document with SharePoint pdfs attached they are not coming through on the data shuttle. Previously my boss was doing the data shuttle and the pdfs came through and allowed us to select and view them. I'm unsure what I'm doing wrong. Both of our excel file types are Microsoft Excel Worksheet.
-
Global Update Error 1031 on renaming a column
I am getting this error when trying to rename a column titled "Key Accomplishments this period" to "Key Accomplishments" Error (1031): INVALID_COLUMN_INDEX: column index is outside of the bound or duplicated. Can someone help?
-
DATAMESH
Hi, I have a config call claim to master which everytime i update it in claim it updated the column in the mastersheet. I have another config from the master to claim with all columns including the 4 in above so everytime there is a change it will show in the claim sheet. Needs to update immediately. I don't know why, it's…
-
ODBC links are slow to update
Has there been a change to the system recently affecting ODBC links to data? I have a sheet that has been running for around a year which pulls together the results from several forms - the ODBC link is set to run automatically as soon as the file is opened, and up until a couple of weeks ago this was relatively quick…
-
Cell Links from Intake Sheet to Profile Sheet
Hello all! I am a relatively new SS Admin and would like some assistance understanding the Profile Sheet - Intake Sheet Relationship. I just added new data items to the Profile Sheet via the Global Updates in Control Center. However, in the new partitioned blueprints, there is no incoming (blue arrow) cell link from the…
-
Dynamic View and figures on EU-SERVER
Hallo all together, I am a German User and I am working with Dynamic View. As you know the comma and the dot are used in USA different as in EUROPE. 1,000.00 vs 1.000,00 My settings in the Smartsheet Core are fine but in Dynamic view I have to use the US notation. Are there some additional settings somewhere around? Best…
-
Control center global update error
Hi Brian trust I have added added a column with a column formulas - the formula is working and giving me the text i need BUT when I go to control centre to add and run a global update it gives me a syntax error on the test run =IF(NOT(ISBLANK([External Contact]@row)), [Project ID]@row + ", " + [Project Name]@row + ", " +…
-
Zapier automation no longer working with Smartsheet (all of a sudden)
Hi all, It's a week of things all of a sudden not working after 6 months of a Zap automation working it's just stopped today. On Zapiers end i've contacted their support and we've troubleshot everything, it's all good on their end. I have a custom Zap that when some data is makes it's way to a certain point in the Zapier…
-
Docusign Integration and Column Tracking not working properly
I am having an issue with Docusign and the Tracking Column not updating properly. About 90% of the time - when the docusign document is signed - the tracking column will update to "Completed" in my tracking column. However, I am having issues with some rows that are not updating correctly. The Tracking Column shows…