-
Getting attachment when attachment is added or changed to a row.
I dont know much of programming and I am not a developer. But I would really like to get attachments from a row in Smartsheet. Posibly automated, so when attachemnt is added or changed in a row, this triggers API. I was looking for a simpler way to do this, either directly with smartsheet, or with a third app like Zapier.…
-
Transfer of a workspace to another SMARTSHEET Business account
I have worked for a client to create a reporting workspace with multiples files and combined sheets. What is the way to transfer this worskpace and its property to my client who has a business Smartsheet account? Thanks in advance to share your advices and tips
-
Automatic creation of sheets
Hi, I'm wondering if there is a way to automatically create a tracker from a template when a row is added to a master sheet? So, I'd have a form add rows to a master sheet, then I'd like that to automatically start an individual tracker that I've setup as a template. And can those trackers be automatically saved in another…
-
Updating rows with multi_contact cell?
Hello, I'm using the Python API to update some rows as follows: copy cell values in specific columns from an old row, and append these to an update request as cells in the respective column for a new row. This works for all but a contact column (with multi_contact enabled). I'm getting the error that I need to use…
-
API Access to Column Formulas
I have been trying to understand how to handle column formulas and all I can see is that you have error messages to let us know that we can modify cells in columns with column formulas but there is no column attribute to indicate that a column formula is present via the API. Also, when a column formula is present, it is…
-
Hyperlink in Help Text
Hi everyone, I am creating a form in smartsheet and was hoping to create a hyperlink in the help text. It says here that we can include hyperlinks but every time I press right-click the option to do so doesn't seem to appear.
-
1006 error on an update to sheet with references
I am having trouble making an update to a sheet. I am confident my code works because I can make successful updates on a test sheet that I setup. I created the test sheet by doing a 'save as new' on the original. So all the fields are exactly the same. I think the issue has to do with formulas and references to other…
-
Python API - Getting Started
I'm barely getting started with Smarthsheet's Python API. I'm trying to get current user by using smartsheet_client.Users.get_current_user() but instead of getting a json response such as { "id": 48569348493401200, "email": "john.doe@smartsheet.com", "firstName": "John", "lastName": "Doe", "locale": "en_US", "timeZone":…
-
Purchasing Request Form in Smartsheet
I want to produce a purchase request form in Smartsheet and I'd like to bounce a few ideas off the community. Please see the attached sample of what's used now. Originally, I was hoping to use Document Generator to map the fields of a fillable pdf to a Smartsheet grid and then have people fill in this PDF to populate the…
-
Smartsheet API Error code 1012 and Status code:400
Hello Team, We are getting this Error code 1012 and Status code:400 (Bad data request )when we try to Add rows/Post data in the smartsheet using Smartsheet API. We have index 0 as Unique ID of Text/Number data type and it holds values. I have tried to clear all cookies and caches from web browser, and verified the URL…
