-
CopySheet Include Automated WorkFlow & Alert Options
Is it possible to include the Automation setting from a "template" to the new target smart sheet using the "smartsheet.SheetResources.CopySheet" function? Dim newCopiedSheet As Sheet = smartsheet.SheetResources.CopySheet(TemplateSheetId, destination, New SheetCopyInclusion() { SheetCopyInclusion.ATTACHMENTS,…
-
Donut Graphic / View
Is there a way to fix this? Sometimes you can have lines (separators) from the numbers; but this is a jumbled mess. Even if I changed the chart type, I would need to adjust the axis to start the numbers at a lower point, so that views, correctly.
-
Are webhooks a premium feature in Smartsheet?
Hi All, I'm in the process of building an app that utilizes Smartsheet's API and I would like the code to run whenever a change is made to a particular sheet. In the API's documentation, it appears that "Event Reporting" and Webhooks are my two best options. However, Event Reporting is a premium feature that is not…
-
Sum cell from last row - multiple sheets
Hello. Looking to sum a specific cells from multiple sheets. Have 5 sheets. Columns are the same across all five sheets. Looking to take the last entry, say for column 1, across all five sheets and sum those values. That value would live in another sheet. Any ideas? Thanks Shawn
-
Smartsheet Live Data Connector ODBC issue with SSIS package
Greetings, I installed and configured both the 32 and 64 bit of the Live Data Connector on my machine and created a SSIS package to read from a Smartsheet and write to a SQL Server table. The ODBC connection is made via an access token and my own credentials (we use SSO to log in). From my local machine, the package runs…
-
Backup tool for one user only?
I am using the backup tool provided through the below link with SmartSheet. The issue we are running into is that we do not need it to backup every single user (this is time consuming and bloats to over 3 gigs of data currently). We are looking to keep this more targeted if at all possible. Has anyone had any luck altering…
-
Conditions only flow to the first on the left
I set after first approval process, it will seek a 2nd level approval base on 4 conditions to 4 different approval. but the flow do not move if the 2nd, 3rd, or 4th conditions is met. It only work when the 1st condition is met. please help
-
Failed to send a single value to a multi-select dropdown column
Hi, I have a multi-select dropdown column on my Smartsheet, I am trying to send a row from Excel to Smartsheet. Let me make an example, I have two salespeople John and David working on this project called test123, after salespeople finished entering on local Excel, they need to send entire row to Smartsheet, however it…
-
Hide details in a sheet
I am working on a sheet which contain multiple country wise data. i will share sheet to all country wise reviewer to update information.. i want to hide sheet data and show only respected country data to end user.. how's is possible.??
-
search api doesn't pull up partial matches or numeric search
Hi, I'm using smartsheet integrations and use search API to get the queried sheet name. https://api.smartsheet.com/2.0/search?query=myquery&scopes=sheetNames Example: Assume that these are the sheetnames I have created a sheet a ac sheet ac sheet account sheet account10 These are the issues When I query "a", it returns…
