-
Data Shuttle Not Updating Cells - Can Any one Assist
I have set up a data shuttle to export a list of e-mail addresses, with one other collum which is an autogenerated number which is the unique ID, this works fine. When I came to run another data shuttle to import this file into another sheet, I set up the settings, selected the unique ID to the autogenerated number collum…
-
Offload and Upload (Data Shuttle)
I was following the instructions here to automatically update dropdown values, but could not get the offload to work (as in the workflow runs successfully, but does not create a file). Thanks for your help.
-
Dynamic View- using multiple contact columns to restrict access
I have a dynamic view that used to give access based on two columns (if you were in the Contact or Back Up Contact - you could see that row). On Tuesday this functionality was no longer working (the page would not load for anyone) and I went in to fix it and had to select the restriction just on one contact column- I…
-
dynamic view in dashboard based on user role
How can I make a dynamic view in dashboard that would restrict information based on the role of the user. Also I read a response to another question on how to create multiple dashboards and show only one of the five based on the role of the user, but they didn't describe how!
-
DataMesh - Lookup value in Source deleted - target keeps stale data?
Hi all, when a row lookup value column is deleted in the Source sheet, this change is not being updated in the target. I'm mapping two sheets based on a unique key, and run data mesh. All selected columns are now copied over to the target. But when I now delete a row in the source, the next time DataMesh runs the data in…
-
Using Data Shuttle with Google Drive as the target exports the file in XLSX format
"When using Data Shuttle with the Target Location set to Google Drive, we have the option to select the exported file in either XLSX or CSV format. Is there a way to automatically convert the file to a Google Sheet directly within Smartsheet?"
-
Data Shuttle Issues
I am using Data Shuttle to export certain rows that meet certain criteria from a sheet. The goal is to have this run during a certain window of time, check where the criteria are met, put the rows into a csv file, and attach it to the same sheet as the source, replacing the old with an updated one every 15 minutes. The…
-
Is there a way to send formatted links to Dynamic Views through Automation?
I have automation workflows that send notifications to employees when new rows are generated. Those employees need to interact with the rows and we use Dynamic View to make the inputs behave more like forms. It works well, except that the only way to link the automated notifications is by copying and pasting the whole,…
-
Bridge - Filter an Array Object by a Particular Field
I have an array of objects that I need to filter and find a particular field in Bridge. ex. [{name: 1, id: 123}, {name: 2, id: 321}] In this case, how would I select the id for the "name" key/field whose value is "1"?
-
Smartsheet Add On in Outlook
What don't my Opportunities populate when the sheet opens in the margin in Outlook?