-
Show Pivot app column results in 2 separate columns
I am create a pivot table using pivot app, and it takes the 2 columns I am using and places them as a parent child in one column which is fine, but when I try to chart the results there is no way to separate or filter the chart to show either the parent or the child data independent of one another. Is it possible to use…
-
Connector between Sales Force and Smartsheet
We have a Smart Sheet connected to Salesforce. However, the dates are being changed automatically in the smartsheet. One option is to lock the rows so the cells cannot be edited. Does this affect the connector between the Sales Force and Smartsheet?
-
Inconsistent formatting in Dynamic View
This discussion was created from comments split from: Inconsistent Formatting in Dynamic View.
-
How can I add conversation to a specific row id in Power Automate using excel as connector?
Hello, I am currently working on a flow in Power Automate that connects with Excel to update specific rows in Smartsheet. The goal is to add a discussion to a row in Smartsheet by adding an email as a comment to a specific row id. However, when I filter for the row id, the output is displayed in number format with commas.…
-
Workapp - Dynamic View permissions
This discussion was created from comments split from: Workapp Permissions.
-
Seeking help with Dynamic View and Automation without Hook-in to Active Directory
Hello Smartsheeters! Hoping you can help figure things out. We're currently using Smartsheet but we're not connected to our active directory. Given the way we are currently set-up, I created a smartsheet solution that would contain automation that would send someone an email with a link to a dynamic view. I tried to enter…
-
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.
