-
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?
-
Another Thank You: Lessons Learned
I really appreciate this (from status.smartsheet.com) Craig
-
Identifying Main tasks & Sub tasks / Identifying last child nodes in hierarchy
Hi All, I'm new to Smartsheet. I would like to know how could I get to know a task is a Main task or Sub task using Smartsheet APIs, My requirement is to consider all the Subtasks (Child rows) in a smartsheet for some calculation purpose. When I see a smartsheet, I can do indentation and I can recognise which is Main task…
-
I cannot manually re-open manually collapsed columns.
I have collapsed a few columns manually by dragging its header row borders but are now unable to open them back up. Even if I use my browser zoom button to precisely select the border the double arrow cursor will only select either column to the left or right of all the manually collapsed columns. I can verify the columns…
-
Commenting your code
Where do you comment your code? When working on a big sheet that you may have to come back to months from now, or a system of sheets you are working on with other Admins, how do you document code 'inline'? Hidden columns? Attachments? What have you found successful?
-
Webforms | Survey - Customizing Column Headers or Question Content
I currently use an external tool to conduct 200-300 surveys and collect data on project performance for my org annually. Data is exported from the tool and compiled in excel. I want to transition to SmartSheet to alleviate the manual survey creation and lift and shift of data. Problem: Each survey is customized listing a…