-
Getting GroupMembers of Group using JavaSDK, Smartsheet API
Hey Community! I'm stuck at a certain point in my development process. I need to receive a list of all GroupMembers of a Group in Smartsheet. I tried the following: //First, getting all groups of our smartsheet plan and storing the result in variable grouplist //Iterate through all Groups... for (Group g : grouplist) { //…
-
Magento
Has anyone got any positive experience with linking Magento to Smartsheet? eg just to populate a sheet with orders recived etc.
-
Access resource view through the API
Hi team, Does anyone know if there is a way to access the Resource Views using the API? It would be huge if we could export that data programmatically (as we can do from the UI). Thanks
-
Automatically add rows when report refreshes
I have a report that's running every day against a single parent row to grab totals. A few cells of that one, single, lonely row. I'm looking for a way to automatically copy the report's information into another sheet daily, that way, over a period of 1 week, 1 month, etc., we can see the changes in the totals. This is…
-
Multiply total project cost by percentage to get sale price
Hello! This is my first post, and I know the answer is simple, but here it goes: I want to take a total project cost column and multiply it by a percentage that is inputted into another call, and have the answer populate an "Extended Price" column. Eventually I want to be able to add subtotals and do the same thing, but…
-
Smartsheet API Webhook basics
I want to update a note in Nutshell CRM when a smartsheet comment is updated. I'm just focusing on the smarsheet webhook at this point, and I have read the webhooks section on the smartsheet API documentation and I still have no idea how to send the request. Where does this stuff go? curl…
-
POST request to fill a column with type PICKLIST
I'm using php-curl to add rows to a sheet throught POST requests and it works good to fill all the text fields. But when I try to add data for a column that has PICKLIST as type it won't work. So this is how the column is structured. { "locked" : true, "type" : "PICKLIST", "index" : 5, "title" : "Severity", "lockedForUser"…
-
Accessing HomeRessource of specific Users via JavaSDK
Hi there! I'm developing a statistic tool for monitoring file creations with smartsheet in my company. First of all, thanks for the brilliant Java SDK, that makes live so much easier when trying to integrate Smartsheet in other applications! Currently I'm at the point where i have to access every user's home directory, to…
-
Backup - Link attachements to row ID/number
Hi, When you make a backup of a sheet with many attachments such as pictures and pdfs these will all be downloaded to one big ZIP folder. Say you have 500 rows with attachments, there is no way to link the attachment to the right row. Is it possible to automatically rename attachments as you upload them? With row number or…
-
Limits!
I don't understand why SS would limit their sheet to max 5000 rows, Google Docs as example allow up to 2 million cells for spreadsheets that are created in or converted to Google Sheets. Can you at least double the limits to 10K?
