-
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 + ", " +…
-
Archiving feature in SCC not moving folder to archive workspace
I've set up a archiving workflow using an archive checkbox column in our intake sheet through our blueprint. When this criteria is met, the project is supposed to be moved into an archive workspace, the intake row should be freezed, and the entries will be deleted from summary sheets. However, I notice that the project's…
-
Anyone has a problem Datamesh error code 1302;You cannot edit cells with Column Formula for column(0
Dear Support, I created a Datamesh with lookup value from a Formula column (source column), once run the config, then show error "code: 1302; message: You cannot edit cells with Column Formula for column {0}" Is Datamesh unable lookup from any formula column? Anyone have the solution yet? Best regards, Napassorn C.
-
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!
