-
Invoice generation for multiple line items
Is there a way work around to generate one invoice for multiple line (example 10-20 items). I tried document builder but we can be able to generate one invoice in the row level.
-
Why do the dates change in the fillable PDF?
Hello I am making fillable PDF and I was trying to put a birthday in them and when it loaded it came out as (Not real) 04/05/23. I have changed it in the smart sheet cells where the dates read out as April 5, 2023 but when it hits the fillable PDF it changes to just numbers. I need it to be spelled out does anyone know why…
-
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…
-
Export Smartsheet as CSV using API - "media type not supported"
I'm able to export a smartsheet document as JSON with the API, however, our endpoint doesn't support nested data. So I'd like to get it either as flattened JSON or CSV. Sample #4 here shows the CSV option: // Sample 4: Get sheet as CSV curl https://api.smartsheet.com/2.0/sheets/{sheetId} \ -H "Authorization: Bearer…
-
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…
