-
Datamesh not pulling source data for duplicate entries
I have a sheet that serves as a log for repairs to equipment. I set up a config to pull equipment detail from sheet A into repair log (sheet B) using equipment ID as the look-up value. Users use a form in sheet B to request service. If multiple requests are submitted for the same ID number (which is common as equipment…
-
Are there alternatives to the Smartsheet conditional formatting options?
I have a sheet (part of a set so there will ultimately be many sheets) that will need in the neighborhood of 10,000 conditional formatting rules. Supposedly there is no limit to the rules, but I have definitely found the limit where the sheet functions well. Right now I have about 1,800 rules and when I open the…
-
Take Multi-Contact from one sheet to another in Bridge
I have a form that users fill in to log risks, they can select multiple risk owners and assign them via a multi contact cell, I then use bridge to auto divert this risk to the respective register.. Unfortunately Bridge does not recognise multi contact to pull into the cell and I get an error.. has anyone been able to…
-
Data Shuttle will not find columns in source file
I am trying to setup an upload workflow where I bring data from an excel spreadsheet into a sheet in Smartsheet. The Data Shuttle workflow will not find the columns in my source sheet. The column headers start on row 2 in my excel sheet but the mapping portion of the workflow builder will not find the columns. Any…
-
Best option for a simple cross-table join.
I want to do what I think is a simple cross-table join. I have a table with a list of project week start dates (lets assume 40 weeks). I have a separate table with a list of all resources working on the project (lets assume 20 resources) I would like an automated way to create a new master table which has a row for unique…
-
Data Shuttle is not finding all columns in the source sheet
I am trying to use data shuttle to upload data from an excel file in SharePoint but when I get to the mapping part, the column names are completely different from the source. Almost as if it is not pulling the data from the sheet I specified, but a different one. I am using the second tab of the excel sheet and some of the…
-
Data shuttle upload error to client sheet with a locked store id column
Seeing if anyone has a similar experience or guidance. We have two sheets which we are using data shuttle between: • Client project tracker • Internal project tracker We have setup matching column names and types, which we want to use data shuttle to communicate updates between our two sheets. We pull unique store numbers,…
-
I cannot filter Date fields in Dynamic View, why?
I have a Dynamic View that contains both Text/Number and a Date field on the Display view. I seem to be able to filter every other field but the date. Why is that?
-
Data Shuttle Data And Automation
Hello, I’m running into an issue where Automations aren’t running in a workspace I created. The workspace is in Table View and uses a Data Shuttle to bring in information from a Google Sheet containing form submission data. The first three columns of the workspace are not linked to any Data Shuttle data, while the…
-
Smartsheet Outlook plugin/add on
Hi, one of our users is trying to use Smartsheet for Outlook plugin/add on and is always asking for Admin approval to use it. How do I grant consent for my users to use the Smartsheet for Outlook plugin. We are using M365 email service.
