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.