-
Input expression in Data Shuttle to create a unique identifier?
Hi all! I've been trying to figure out the use of expressions in Data Shuttle but haven't been able to figure it out, so I'm hoping someone here will be able to help. I have a sheet set up with a Data Shuttle workflow which pulls data from a report in Excel. In order to get a unique identifier, I need to combine the data…
-
How to prevent data shuttle from converting excel text to number
An excel xlsx sheet has some data saved as text that data shuttle is converting to number even when the workflow column type is defined specifically as text. For example '2526 in excel is coming in as 2526 (without the leading ') and causes formulas not to work. The exact same excel sheet can be imported manually (not…
-
keep getting cell limit with data shuttle and no where near limit
Hi, i have 91kish cells, which is not the limit but keep getting an error that it's maxed out with data shuttle. The error: "Your sheet exceeds the cell limit. start using table view to increase sheet capacity or manually move rows to another sheet." This makes no sense, there is no setting other than on the sheet itself…
-
Template with Dynamic view and Control Center
One of our templates relies on dyanmic view. Will the settings for Dynamic View stay in place when new project is created? All projects are created using Control Center. I've already searched in the Community, looked a articles, and learning.
-
Logging Attachment Names
Is there a way to put the name of an attachment in a row into a cell in the same row?
-
Is it possible to filter reports by project name in Control Center?
Is there a way within the blueprint to automatically filter my reports by the project name? I'm currently creating projects then manually changing the filters to reflect the correct project names.
-
Power Automate ‘Add a Row’ sends numbers as text in Smartsheet
I’m using Microsoft Power Automate’s “Add a Row” action to populate a Smartsheet. Everything comes through correctly except the numeric fields I need to total later: In Smartsheet the values arrive as '1 (text with a leading apostrophe) instead of 1 (numeric). Because they’re stored as text, my column =SUM() formula…
-
Entra SSO
last day or so we have been getting issues launching SSO via Entra (OIDC), but when going to the smartsheet directly its good…browsers report too many redirects cleared all browsers, multiple PCs, clean pcs, etc…any one seen this?
-
Data Shuttle Not Working: Please select a Source in order to see dropdown options
I keep getting "Please select a Source in order to see dropdown options" when attempting to setup a Data Shuttle workflow. See screenshots below. This is keeping me from being able to transfer updated data from "Local copy" spreadsheet to "Actions" spreadsheet. Both sheets are within the same workspace and have the same…
-
Embed Asana Read only link on smartsheet Dashboard
Is this doable? I have a link. Is there a way I can write a code to disable asana? Asana is not listed here, https://help.smartsheet.com/articles/2480561-embed-content-from-various-sources-in-a-dashboard ,but I was hoping there was a work-around. I do not want to bring any Asana data into smartsheet (ie I dont want to use…
