Add Ons and Integrations

Archives for November 2020

File Names of Generated Documents
Would love to be able to have the file names for Generated Documents from the Document Builder be dynamic. If we could have it concatenate text from a field/column that would be ideal, similar to the {{column name}} function we have in automations. Right now it just names them all whatever the template is.
Data Uploader error : "No input columns found"
Hello everyone I am using Data Uploader and I have randomly encountered multiple times the following error : It happens when : I create a worklow on a sheet and the workflow is correctly triggered with the attachement Then I modify some data manually in the sheet When I add a new attachement, nothing happens so I create…
Live Data Connector (Data Extract from Excel Worksheet)
Who can answer technical questions about Live Data Connector to extract data from Excel? Trying to determine if one can: Include full path to Excel workbook in Smartsheet cell Include name of Worksheet in Smartsheet cell Point to designated Excel Worksheet in designated Workbook Transfer data based on Excel Worksheet named…
How to change the settings of document builder so it stops cutting off my text?
I have my PDF and smartsheet mapped out to match one another and when I preview my generate PDF, the majority of text gets cut off.
WorkApps - Can a User jump into the "real" sheet?
I have created a nice WorkApp with a few sheets to help my team with the 2021 budget process. Very nice. I was able to make it so they could EDIT from the WorkApp's view as well. However, there are times when they want to jump into the full Smarthsheet from there. maybe to filter or add rows or go to other sheets. Is there…
How to get industry event to span multiple days in Calendar App w/o entering each day separately
Do you know if there is a way to get an event that I entered into a row to span multiple days in the Calendar App without entering a row for each day the event is taking place? For instance, there’s a convention that is three days long and I want it to show up in the Calendar App view on all three days. Do I need to enter…
Anybody been able to import a tab delimited file in Data Uploader via Google Drive?
I have a tab delimited file, but its normal extension is .txt which Data Uploader will not see when picking a source file. Renaming the same file with .csv doesn't work either. The same file, regardless of extension, loads just fine when opening via a sheet attachment.
How do I link a field in metadata to its metadata in a Blueprint
Hi, I have a Blueprint setup with a field "Risk - Open" in the Blueprint but not included in the profile data selection so does not appear in the Portfolio Summary Rollup sheet. but already exists in project metadata sheets created from the Blueprint. I have selected this field in the Blueprint portfolio data selection and…
Deleting an attachment in dynamic view?
It seems that regardless of settings/permissions, you can't delete an attachment from dynamic view, even if it's an attachment you just added in dynamic view. Is that accurate?
Pivot App- Error! Column titles are not unique among input columns. (1133)
I am unable to run a pivot due to above can you help? Also dates are pulling into piviot app using US style not UK, any ideas?

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