Sign in to join the conversation:
Does anyone have an example of how to query for all sheets that were created using the project template?
Thanks!
Hi Neall,
Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)
I hope that helps!
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
Thanks Andrée - I don't have any specific screenshots to show but what I want to do is query the API to get a list of projects. I'm looking to do some integration and want to verify if a Project already exists. Hence I don't want to get a list of all sheets, just the sheets that were created using the project template. Unless there is a better way to determine that a sheet is a project and not some other use.
Hope this makes sense - I'm new to Smartsheets and from what I'm seeing it's a very flat structure.
Neall
Happy to help!
I'd recommend checking in the Developer Community as well and in the documentation, if you haven't already.
Andrée
I have a report that beautifully aggregates data from 70+ sheets. I need one column from that report to populate a helper sheet that I have: Source Sheets > Report > Helper Sheet As the report grows with data, I want the helper sheet to grow with it without manual intervention. Ergo, the API question. Here's what I know…
We're looking to create a Gantt chart by inserting the data and creating the chart via the API (actually via the Java SDK, but either will do). Inserting the data is fine, but cannot seem to get the setDependenciesEnabled (which believe need for the Gantt ) or setGanttEnabled() to work… We think part of this is the order…
Hi, Since yesterday (dec 18), many calls to the api are failing or taking way longer than expected (2500seconds to read a sheet). What is the current server status and when should it be back to normal ?
