-
Need a formula to count how many of each Support Type is assigned to each Assignee.
For example, for the DFM/DDFM Support Type, I would like to know that there are: Communication: (1) Ashley Pierce (1) Tanner May Proposal Review: (1) Alexa Briggs (2) Ashley Pierce
-
what is the size limit for a file attachment via API
I have build a webpage that uploads attachments to a row in smartsheet. It works fine for 12 MB file. But I have been trying to upload a file which is 100MB via API to a row, but everytime I get below error: {"response": {"statusCode": 500, "reason": "Internal Server Error", "content": "<< text/html;charset=UTF-8 content…
-
Microstrategy
Hi all, I searched and I didn't find anything for this so I am hoping I did not just miss this. We are trying to tie our data into Microstrategy for more visualization options. We are using the Live Data Connector. Has anyone been able to successfully integrate Smartsheet and Microstrategy? If so, I'd like to speak with…
-
Error 1012: 'Required object attribute(s) are missing from your request: values.'
I'm having difficulties with the AddRows method in Smartsheet's C# SDK. I have been getting the error code 1012 with the message 'Required object attribute(s) are missing from your request: values." I have seen others post similar issues but with 'cell.value' as the missing attribute. In my case, what is 'values' supposed…
-
Automated emails
Hi, Is it possible to change the "from" address when sending automated alerts/update requests? Or is it always the default SmartSheet address? Thanks
-
Time Formats - Number formats - Rethinking the UX and function
Having an entire dialog for text and number formats would make much more sense to me.. combine the currency, percentage, thousands and decimal places into it's own dialog box. We really NEED a way to save and modify the formatting of common things. So as to have them available and globally modifiable across workspaces. Use…
-
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…
-
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…
-
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…
-
Automatic report creation with custom template
Hi! I am working on creating a report in which data is obtained using a Smartsheet form. For each new answer on the form, a new report or Dashboard must be created, which must have the format below. I wonder if there is any tool, API or integration with any other platform that would make this possible? Any help is much…