Add Ons and Integrations

Archives for March 2021

Control Center Blueprint Choice
Hello everyone, Could you please help me to understand in which situations I need one or several Blueprints ? I have the feeling that If I have a project management relatively linear that is always the same, expected for some rows or columns in my sheet, I can keep one Blueprint and add optional templates to choose when I…
Global Update Formulas Blank?
Regarding Control Center Global Update: I went to add an index/match formula column to a metadata sheet in order to label every line with a unique ID (which is shared across a single project otherwise). When it brought up the preview, the column was entirely blank -- Is this normal? It wasn't adding a column formula, nor a…
Is there any cloud-based reporting platform that works well with Smartsheet? Text reports, not viz
I use the live data connector and MS Access to report smartsheet data, and it works great for my purposes, but I want to distribute reporting capabilities enterprise-wide. Are there any cloud-based solutions to transform Smartsheet data into reports. Here is an example of what I am talking about, it's pretty simple:
Power Automate only filling up to 100 Columns
I'm running some flows and I have about 150 Columns. When I use the Insert Row function it stops working after 100 columns. I don't really want to move things around but is there any idea as to why it would stop?
How to set the start of Q1 within the Calendar App?
We have a really nice timeline view of our work using the Calendar App and it would be really handy to be able to display the Week Number or even view by Quarter. However the interface doesn't seem to honor the the "Quarter Start Month" setting and always uses February. I expect Q1 to be from Jan 01 to Mar 31, not Feb 01…
Connect attachments to JIRA
I have created a workflow that connects Jira to Smartsheet and it is working ok apart from the attachments that do not feed back to the Jira ticket. I tried to amend the Workflow but there is no field that corresponds to attachments. Any suggestions? Thanks Aimilia
control center ppt with examples
Hi community, Hope all are doing well. Have to present the PPT over control center with examples. I want to talk about blueprint , so i need blueprint related examples with real time scenarios. Ex: Blueprint - related examples with related screenshots Project: related examples with related screenshots. Please suggest how…
Adding a new SHEET to Control Center projects
Is there a way to have Control Center add a new SHEET to existing projects? I can add new reports and dashboards, and I can add new COLUMNS to existing sheets in a project, but is there a way to add a new sheet? At the very least, if I cannot automatically add a new sheet using control center, can I at least manually add…
Create Chart from Dropdown (Multiple Select)
Hi and Thanks In Advance, Essentially I would like to create a chart based on one column of Dropdown (Single Select) data (Status) and one column of Drop Down (Multiple Select) data (Goal). I'm aware I will probably need a helper column somewhere in there, but I cant get ym head around what it might be. Each row of data is…
Calendar App - Details view of multi-select fields
Hello! On Calendar App, I'm having an issue with multi-select fields not showing up on the details view when multiple items are selected. However, when only 1 of the multi-select options is chosen, it does appear on the details view. See screenshots attached. Any ideas? My workaround for now is to include the multi-select…

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…

Add Ons and Integrations

Discussion List