Add Ons and Integrations

Archives for February 2021

Copy/Move Attachments between sheets
I am currently using DataMesh to copy data from one sheet to another and wondering if anyone has ideas/options on how to get attachments copied over to the new sheet as well. I can't use the copy row feature because there are a number of rows on the original sheet that are unnecessary, and the column names are different on…
Electronic signatures on Smartsheet Forms
I was wondering if there is a solution yet for electronic signatures to be captured within a Smartsheet form. We have visitors and contractors that are required to sign in and out when they enter and leave the building. We are trying to reduce the abundance of paperwork by making this form electronic; however, due to…
Is anyone using Calendar App? Would like some feedback on ROI from any users.
I'm trialling Calendar App and thus far it's mostly answering the question of how we can get a swimlane view generated from a gantt chart to push the team forward. However that's a limited application for such a high investment so I would like to hear from anyone else who is using this as to whether there's more to get out…
Salesforce Connector: Edit workflows when you are not the creator
Good Morning coummunity, we are just connecting the Salesforce connector to our Smartsheet and got to learn that ONLY the workflow creator can change the workflow if necessary. All Admins can see the workflow (at least ;-)), however in absence of the workflow creater there is actually NO possibitly to change the workflow…
How to Workapps transfer ownership?
It is possible to transfer the ownership of an app made in Workapps? I made an app and i want to transfer it to a colleague, is this possible? Thanks!
Pivot Help
I have a sheet with a hierarchy broken down by region and country. Under each country is the name of a worker. I'm trying to create a pivot to count the number of workers per region and per county. I've tried is so many different ways and cannot figure out what to select for the rows, columns and values. Thanks!
Smartsheet - Procore & Cyberco Sync
We just started creating schedules in Smartsheet and are trying to sync them to Procore via Cyberco and running into issues. Cyberco's site is vague with little in ways support material. Would love to hear some experiences / input on this subject.
Data Uploader to a Sheet where primary column is calc of system generated
I am trying to use Data Uploader to update a Sheet where the primary column is a calc of a system generated column. Primary Column =[System Generated@row Uploader will run but it skips all of the rows on the source spreadsheet. Is what I am trying to accomplish not possible?
= SUMIF(OR.......
Hi Smartsheet Community, I wondering to know if it is possible to make a "SUMIF (OR.." : I explain: In Sheet 1 = SHEETDATA I have two columns with data (reference of product) and one with a number (size of reel) As example: LIGN1 : I can choose REF A in cell column1, REF B in cell column2, and 30 in column 3 LIGN2 : I can…
Data Mesh - Not matching some lookup values and not mapping data
Hello, I am using Data Mesh for the first time to move data from multiple source sheets into one target sheet. I've completed my first configuration from one source sheet to the target. I ran the configuration and a lot of the rows in target sheet were updated, but some were not. I've gone back to make sure that the values…

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