Unique Row Identifier For a Workspace

IKatz101

Hello,

I need to have a column for all sheets in a Workspace which has a unique ID for each row. I know that I can use the system generated auto-number for the column however I need to ensure that the ID in the cell is unique for all sheets in the given Workspace. Any suggestions?

hollyconradsmith

Hi @IKatz101 ,

You could set up the prefix and suffix of the auto-number to be unique for each sheet. Would that accomplish what you are looking for?

IKatz101

https://community.smartsheet.com/discussion/comment/310848#Comment_310848

Thanks for commenting. This is one solution however I was hoping there would be a solution which is less of a manual process.

hollyconradsmith

@IKatz101 ,

It may be possible to set the auto-number prefix/suffix using the API. http://smartsheet-platform.github.io/smartsheet-csharp-sdk/html/6c604023-fc93-fa83-2132-6f28a625c094.htm

However, beyond that the most "automated" way would be to set the prefix and/or suffix for each sheet.