Forum Discussion
Generate autotext + number in column in SP list
Hi everyone, I've been looking everywhere for a solution to my problem. I've made a list that has all sorts of machines. Our intern ID is specified by a set of letters like: BTARM(+number of...
If you are looking for the MAX([InternID]) to return the maximum value of InternID in the list, that is not possible. The formula can only use other columns in the same item(row).
If you are just trying to concatenate the custom text with the InternID from the same item, try the following formula:
=IF(ISBLANK([InternID]),"BTARM1","BTARM0"&[InternID])
I'm not sure that is exactly what you are looking for, but hopefully will get you close enough to adjust for yourself.
Here are some additional references
- https://learn.microsoft.com/en-us/previous-versions/office/developer/sharepoint-2010/bb862071(v=office.14)
- https://support.microsoft.com/en-us/office/examples-of-common-formulas-in-lists-d81f5f21-2b4e-45ce-b170-bf7ebf6988b3
- https://www.spguides.com/sharepoint-calculated-column/
Good luck!
Don
If my answer helps solve or resolve your issue, please consider clicking Mark as Best Response & Like. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it a Like.