-
Is there a better way to completely remove user access via the API?
Hello, We're beginning to look into integrating the removal of a user's Smartsheet account as part of our employee offboarding process. My intent was to use the API for this functionality so that it could be automated. Unfortunately, I'm not finding the API endpoints available to accomplish this task in a relatively small…
-
Why are smartsheet emails being sent to my junk folder?
Hello i am currently working a on a smart sheet automation for a project and i have ran into this issue where my emails are sent to my junk email. I need these emails to be sent to multiple different people at random times and not in their junk email. I checked all my settings as i was previously reading forms from before…
-
Use smartsheet data to generate a document that maintains fillable blanks for the recipient
Use: We are using smartsheets to maintain client progress. We have forms that are pdf fillables mapped. We generate these and then email them to the account manager. At that point, the manager still has information to complete ie- other questions on the form that were formatted in acrobat pro to have fillable blanks that…
-
How to add cell dependancies using (python) API
Hi community! I'm not the API dev, just asking about API capabilities. I know its possible to create dependencies in the GUI by specify a row number for example. If we're creating via API, we may not know the row number. Is it possible to specify the relationship by cell "Task Name" for example. Can I specify a dependency…
-
Banded Rows for Reports
It would be nice if reports created banded rows automatically instead of having to create complex formulas in the source sheet to band rows that flow through to reports. Most of our reports come from one master sheet. If I create banded rows based on one set of criteria, it works great for that specific report. However,…
-
Return column ids when creating a sheet from a template via the API
Right now, the columns array is only returned if you define columns as part of the request. If you instead use fromId to make a sheet from a template, no columns are returned, requiring a separate GET and effectively doubling the amount of calls needed to create a sheet. The column array should be returned in all cases.
-
Columns not returned when creating a sheet
When I am submitting a POST request to https://api.smartsheet.com/2.0/workspaces/{workspaceId}/sheets in order to create a sheet from a template, the response does not include the columns array. I assumed that using include=data as a param would get it done, but the response is the same with or without it. The API docs…
-
Fillable PDF boxes are removed when I replace PDF
Hello, Its not that big of an issue but it is very annoying and time consuming. I have a fillable PDF and had all the boxes on the side I dragged and dropped into the PDF and saved it. It works just fine but I had to make some changes and when I went to the same mapping and went to the settings to replace the PDF half of…
-
API endpoint for summary information reports
Currently when using the Smartsheet connector for Power BI, is not possible to grab sheet summary information reports, only reports based on sheet row line information. It would be very good to be able to gather information from summary based reports on Power BI.
-
Card View - Conditional Formatting
Hi all (Andre you about? haha) I am trying to conditional format on the card view, in terms of striking through the Primary Text (Task Name) when the % Complete column = 100% This works on the grid or gantt view however does not carry over to Card View...any ideas? See attachments Any help much appreciated, Jack