Using Smartsheet

Find answers to your core Smartsheet application, add ons and integration questions, here.

Smartsheet Basics
Post a question about using the core Smartsheet application: Sheets, Forms, Reports, Dashboards, and more.
Add Ons and Integrations
Ask questions about Control Center, Dynamic View, DataMesh, Pivot App, Calendar App, WorkApps, or Resource Management. Discuss connecting Smartsheet to your other systems with integrations such as Bridge, Data Shuttle, the Jira connector, and the Salesforce connector.

Recent Discussions

Data Mesh
I have inherited a couple of worksheets. One of the sheets is basically the dataset and the other is MOSTLY a sheet FULL of links - individually set up links. It works fine to the best of my knowledge, however, I'm wondering if there is something to gain from setting up a datamesh? Are there advantages to datamesh over the…
Planned vs Actual Start & End Dates
Hello, I have data in Smartsheets (pic of SSData) that I need transposed into a chart /graphic. I've attached the view that I need to see or create rather, in the pic called Planned vs Actual_SS (this is something I have created in Excel). Is it possible to replicate this in Smartsheets? THanks
How can I create a chart based on two non-numerical fields?
Hi there! This is probably very basic stuff, sorry for that. I'm struggling to get some basic charts from a sheet that contains some fields related to project (Name, Project Mgr, Project Type, Health(red/amber/green)...) This is my sheet I'd like to have a chart showing how many red, amber or green each Project Mgs has.…
How do I make multiple forms (duplicated) stand on their own to populate the same sheet?
I duplicated a form three times, how can I make them stand on their own to populate the same form? Now when I make a change on one it duplicates that change to all three forms.
Short URL
Has Smartsheets developed a way to shorten long urls
In Resource Manager, how can I add time for contractors that I rarely use?
We have Contractors that we need to enter time on projects. Some of these contractors are used maybe 4 or 5 times a year. I haven't found a way to add time for non-licensed users. But I don't want to burn a license just for 4 or 5 time entries in a year. Anyone found a good way to do this without having a bunch of unused…
Data Shuttle Error Code
Hi, I have a data shuttle configuration that had been working up until the past two runs when I get the same error. My spreadsheet hasn't changed and is not over capacity. There are slightly over 300,000 cells. I attached my workflow for reference. I also attached the exact file except I deleted all rows, but one. Also,…
Query String to pre-fill a form
I am attempting to use JOIN to build a query string and I am able to do it however if the column I join has spaces in the entry, the JOIN only attaches the first word until there is a space. =JOIN([Join Column]@row:DlrName@row, "&DlrName=") results with a query string but only the first word in the column DlrName. How do I…
Problems with conditional formatting on my sheet when it's not listed as a condition
I'm having the weirdest problem on one of my sheets. Below are the only conditions on my sheet, but adding a new task or row applies the pastel yellow to the row. In another cell it's applying a navy background. In the same column it bolds all the text and turns the font color white. None of these appear to be conditions…
Data Shuttle Error "Specified Key Does Not Exist"
In Data Shuttle, I have a workflow that is producing the following error: Unable to add rows to target sheet : UNKNOWN: The specified key does not exist. (Service: S3, Status Code: 404, Request ID: 7FED8H5R7Q5AXB87) This workflow has been operating fine for months (runs twice a day) with no errors and this just started…

Trending in Using Smartsheet

Data Shuttle Error "Specified Key Does Not Exist"
In Data Shuttle, I have a workflow that is producing the following error: Unable to add rows to target sheet : UNKNOWN: The specified key does not exist. (Service: S3, Status Code: 404, Request ID: 7FED8H5R7Q5AXB87) This workflow has been operating fine for months (runs twice a day) with no errors and this just started…
Reupload Data with DataShuttle
Dear All! I would like to create a tool which uses Data Shuttle. Basic idea is to ask user to upload attachment (via a form) which would trigger a data shuttle and info in the attachment would go to a transition sheet from where it would be moved to the target sheet with automation. It works nicely, however, I need to…
Dashboard reports not showing on published dashboard in SharePoint
I have embedded a Smartsheet dashboard in a SharePoint Online site. Some reports show just fine, two do not and I can't figure out why. I published the dashboard and grabbed the embed code. Used an embed web part in SharePoint to embed the dashboard. Two reports show fine, the other two have errors. There is nothing…

Using Smartsheet

Category List

Popular Tags