1

Hoping this will be easy. I'm starting at 900 at need a field to go up one when an item is added to a list. Is there a simple formula to achieve this?

Thanks in advance

  • Are you using SharePoint Online/Office 365? – SharePointer Oct 16 '17 at 19:47
1

A workflow would be needed to take a number that you have and add 1 to it.

Here is an article I found that may help. http://gihanmaduranga.blogspot.com/2012/09/create-auto-increment-number-column-in.html or this http://www.sharepointdiary.com/2014/11/create-autonumber-column-in-sharepoint-list.html

0

I'll second Chris G that a workflow makes the most sense, however in the interest of variety you might be able to get away with using a calculated column based on the list ID number. Say the first item in the list is the one you want to be 900, you could calculate the column as ID (1) + 899. Then ID 2 (+899) would be 901, and so on.

Where this would run into problems is when you delete items from the list, it would create non-sequential items. SharePoint does not reuse ID numbers, so if you deleted ID 2 this column would go from 900 to 902 without a 901. A workflow could add logic to account for item deletion.

0

You can use default ID field which is auto incremental and add 900. If you are on SharePoint online, it would be easier to use Flow. You can hide the field so user don't see this in the new/edit form if needed. I have added the following expression in the MyID2 field.

add(triggerBody()?['ID'],900)

enter image description here

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.