We are using internal ID’s for project identifiers but we would like to write a formula so we can have our project ID’s in sequential order. Can anyone help with this? I have tired looking this up but I am not having any success. I would like our project ID’s to start FY26-0001 etc.
What about using the “Item ID” column? You can customize it to start with identifiers you want.
Desiree - www.thecleverclovers.com
Limitation note: When using custom key prefixes for Item IDs (e.g., changing the default format), these items are not searchable in the global search. Vote for the enhancmenet idea here: Custom Key item ID search alignment - Feature requests
1 Like
Done! I didn’t realize that limitation, thanks Wally.
1 Like
Thank you so much, not sure how I missed that. I think that could work for our group! I appreciate your response.
1 Like