-
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…
-
Issues Connecting Data Shuttle to Online SharePoint Site
We are conducting a proof of concept for Data Shuttle which requires the ability to read and write files from/to an online SharePoint site. While trying to build an upload workflow, I successfully connect and while in the "Pick A file" window I'm ABLE to see my OneDrive folders and company SharePoint sites I have access…
-
Importing new data- updating existing
I'm not sure the best way to complete what I need to do. I imported an excel spreadsheet for accounts that are past due into Smartsheet. Is there a way I can have that data updated when my new report in excel runs (which is weekly). I was thinking on using Data Shuttle, but got kind of lost when I got to the "filters"…
-
Data Shuttle Filter using multiple "does not contain" filters
I am trying to filter out a series of market lines from my Smartsheet that contains dozens of markets using a does not contain logic pathway. Right now i am using the following, but it allows in all the markets. I do not want to use the contains logic since i sometimes get unique identifiers that I want to get in. Is this…
-
Bridge - Auto Delete Newly Added Columns
Hello, I've been trying to create a workflow in bridge that when a Move Row automation happens to a target sheet. There are certain columns that will be delete each time the Move Row automation happens. So in this example, the row is moved to this sheet, because the last two columns aren't in the sheet, I want to delete…
-
Teams integration for Automation
When I attempt to use the Teams automation, I see my domain but none of my teams are there to choose from. Is there a set up step that I am missing?
-
Hello if a user has "view" and "edit" access (Only) and NOT CREATE access...
Hello if a user has "view" and "edit" access (Only) and NOT CREATE access... would this count as an individual user license? Thank you!
-
Changing a text/number column type to a contact column removes all the links into the cells
Hello, I inherited a blueprint and about a 100 projects from a previous admin. The previous admin had some of our contacts listed in text/number type columns in the summary sheet so names were showing up as name+<email>. I changed these column types in the summary sheet to become contact types so the email could be hidden…
-
Offload unique values from source sheet - Data Shuttle
hello all, I would like to use Data Shuttle to offload the list of "submitted by" users and then upload it to another sheet to count the number of submissions per user. Source sheet: Metrics sheet: How could I prevent duplicate names from being uploaded to the metrics sheet? I tried to use a helper column in the source…
-
Control Center adding a project
Hey community, We somehow have a project that is not attached to Control Center. It appears it was rolled out with everything (folders, sheets, reports, Dashboard) but it's not getting the same global updates as the rest of the projects and it's becoming a very manual management. Once noticing the lack of updates it was…