-
Jira connector with tracking Epic % complete by epic name
I'm trying to show the % complete for epics that are in progress but having trouble getting this to work. I have the Jira connector already setup, mapped to a summary sheet with formulas, and finally to an executive dashboard. My ask is how can I pull in the epic name field from the source sheet connected to Jira, onto the…
-
Error Code 4000 "Unexpected Error"
I am getting error 4000 when trying to write to a sheet using python. All it says is "An unexpected error has occurred. Please contact Smartsheet support at api@smartsheet.com for assistance." I have successfully written to other smartsheets using the same code so I do not think it's something I am doing wrong on my end.…
-
Delete a Sent Update Request
Since Smartsheet doesn't have the option to resend update requests that haven't been completed, I wrote a script to pull all sent update requests, filter on pending requests, generate+send new requests, and delete the original request. The problem I'm having is that the delete update request call fails every time. It fails…
-
Can I show Smartsheet data inside Confluence page for free?
It would be perfect if I cuold simply show the Smartsheet information inside of Confluence. No need for further fancy Jira/Confluence integration which I know costs a lot of money.
-
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…
