What are the pros and cons of using the smartsheet URL as a unique ID for indexing?
AFAICT Smartsheet does not come with any kind of auto-numbering system to give sheets a unique ID other than the URL.
The PMO template set here suggests using an intake sheet which will give users as ID (via autonumber I presume, I haven't looked at it yet).
What are the pros and cons of using the URL as the unique ID? It's generated on every sheet and can easily be pasted into a Sheet Summary field and an indexing sheet, to allow lookups into the project sheet from that indexing sheet.
A second query: I'd hoped that the URL would also allow the indexing sheet to formulaically retrieve data from the sheet at that URL, but this doesn't seem possible, i.e. by formulaically referencing the URL and pulling back columns for index formulas.
thanks!
Best Answer
-
Hi @CycleBagEd
Every Smartsheet item has a unique ID associated with it; you can find this under File > Properties. This ID is unique per-sheet and is what the Smartsheet API uses to identify each sheet.
This ID would be much more succinct than the URL, and would prevent details like a URL being pasted with additional strings, such as the view (?view=grid) on the end.
You are correct that there currently isn't a way to reference a cell that houses a Sheet URL to identify the sheet/columns to pull back in a formula. Currently the only way to identify a different sheet in a formula is to set up a Cross Sheet Reference, see: Formulas: Reference Data from Other Sheets.
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Answers
-
Hi @CycleBagEd
Every Smartsheet item has a unique ID associated with it; you can find this under File > Properties. This ID is unique per-sheet and is what the Smartsheet API uses to identify each sheet.
This ID would be much more succinct than the URL, and would prevent details like a URL being pasted with additional strings, such as the view (?view=grid) on the end.
You are correct that there currently isn't a way to reference a cell that houses a Sheet URL to identify the sheet/columns to pull back in a formula. Currently the only way to identify a different sheet in a formula is to set up a Cross Sheet Reference, see: Formulas: Reference Data from Other Sheets.
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives