Welcome!

Querying Smartsheet for All Projects

Neall Alcott

Does anyone have an example of how to query for all sheets that were created using the project template?

Thanks!

Find more posts tagged with

Comments

Andrée Starå

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

Neall Alcott

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

Andrée Starå

Happy to help!

I'd recommend checking in the Developer Community as well and in the documentation, if you haven't already.

https://stackoverflow.com/questions/tagged/smartsheet-api

https://smartsheet-platform.github.io/api-docs/

I hope that helps!

Best,

Andrée

Sign in to join the conversation!

Quick Links

Trending discussions

Alternative API endpoint for listing workspace templates after Feb 2026 deprecation?
With the announcement of the deprecation of "/workspaces/{workspaceId}" and the deprecation of the template listing endpoint (https://developers.smartsheet.com/api/smartsheet/changelog#template-listing-endpoints) There does not seem to be a way to retrieve a list of templates for a given workspace. Our app relies on these…
Auto Create Child Rows from Dropdown; how to get array values to auto populate each child row
Hello :) I am building a project management system where we have: Asset (Parent Object) Components needing fixing/replacement (Child Objects). In my Bridge workflow I have managed to achieve child row creation based on the number of values in the dropdown cell (components). I need to add a feature that spreads each…
Sheet modifiedAt
Hello, I found that sheet modifiedAt field in "List Sheets" GET method sometimes is different than modifiedAt field from "Get Sheet". Is this normal ? When I change a value in a cell, Get Sheet method returns the last modifiedAt date but List Sheets remain with the old value.