nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Smartsheet Community

Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.

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

"Trouble reaching Smartsheet right now" error message on a single sheet when any action is selected.
Receiving this error every time I try to save a change to a single sheet or access the Automation menu. All other sheets are working correctly. I've tried multiple browsers, clearing my cache, restarting the computer and checking for Smartsheet outages. While I'm actively working on developing the sheet further, there are…
Bridge Error: Contact List
Within the Add Row workflow element, Bridge throws this error when I simply trying to send a contact list value from one sheet to another sheet in Smartsheet Bridge. I understand that the "to" sheet is requiring the value to be an email but I can't find the object value in the Run Log. @Genevieve P. hoping you can help.…
Smartsheet API Error: Get Sheet—Missing attachment information when there are more than 10,000 rows
I tested three methods: get sheet (Python SDK) raw HTTP request get row (Python SDK) Method Total Has att Empty get_sheet 11153 4379 6774 raw HTTP 11153 4379 6774 get_row (last 10) 10 10 0 get_sheet (last 10) 10 0 10 raw HTTP (last 10) 10 0 10 I can confirm that every row in this sheet has an attachment.