-
Datamesh can pull from a formula column?
In my source report being used for a datamesh I have a column that is a formula column with a nested IF statement. The destination sheet is set-up to be a text/number field. Other columns work on the same source report are meshing, the one that is a column formula is not…is that the issue here? Thank you
-
Am I doing it wrong? Salesforce connector, Mesh, control center, Data shuttle ugh and now RM
:) Replacing a JIRA system that was not really used well with Smart sheet and Sales force in a united front to try and perform work flow, report out, and track time, then export for billing back to Salesforce. High level, we have a pre sales sheet that captures input from Salesforce on win, loss, and or type of project.…
-
Smartsheet and Teams - open within Teams
This discussion was created from comments split from: Smartsheet Integration for Microsoft Teams apps consolidated and permissions reduced!.
-
Exporting Report's with Grouping
I have researched that currently we cannot export to pdf or excel in the grouping format that it shows in the Report. I have noticed that this has been discussed and mentioned for a few years but little information or anything to suggest it is actually being worked on. When will this be updated/timeline? As I unfortunately…
-
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…
