-
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…
-
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
-
Show my the text file coming from Smartsheet Bridge
Hello, Please give me the json file coming from bridge output, the data reference is not helpful for me to create a json body to call this exact field:
-
Is there a way to optimize drop down menus?
hello i am trying to have certain values only show when someone chooses one value. here's an example: Entity 1 Entity 2 Entity 3 Now based on those three entity there would be a seperate drop down menu with 10 items: Item 1 item 2 item 3 item 4 Ext... But if i choose entity 1 then only item 2 and 7 show but if i choose…