Generate autotext + number in column in SP list

Jonas_Daragas 

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/

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.

Jonas_Daragas you can't do this SharePoint; a calculated column can't loop through all the items in the InternID column to get the max value unlike Excel, it only works across the current item.  But you can build a simple flow in Power Automate to achieve this. Create it from blank, there won't be a template for this.

1. The trigger is the SharePoint when a new item is created. Select your site and your list. Next add an initialize variable action, give it a name and make the type Float. Leave the value empty.

2. Next we want to get the maximum value of the InternID column. So add a SharePoint get items action. Select your site and list. That will add your columns to the action. When it has done so click the Show advanced options at the bottom of the flow. In the filter query field type InternID ne '' and inside the single quotes, from the dynamic content box click the Expression tab and type null then click OK. Click in the Order By field and type InternID desc and in the Top Count field type 1

Even though we are only bringing back 1 item add an apply to each action and select value from the dynamic content box.

Next, add a Set variable action, select the variable name and in the value field select InternID from the get items section of the dynamic content box.

Next, add an increment variable action, select the variable and in the value field type 1.

Finally, add a SharePoint update item action. Select the Site and List, and from the dynamic content box select ID and Title from the create item section of the dynamic content box. Click in the InternID field and select the variable.

In this example the previous maximum value was 76 but after adding the Mauritius item the flow triggered and gave it the InternID of 77.

You'd never have got that solution with ChatGPT!

Rob
Los Gallardos
Microsoft Power Automate Community Super User