Forum Discussion

Copper Contributor

Dec 22, 2023

Solved

Unique Integer Colum in Sharepoint List

Hello, how can I get a column in a sharepoint List which is basically an editable ID. I tried using the number type and set the decimal to 0 and made it unique. That works if users only enter w...

Lists

SharePoint Online

codingpebble
Dec 22, 2023
I solved this using validation:
=IF([Number Column] = ROUND([Number Column], 0), true, false)

DaveMehr365

MVP

Dec 22, 2023

Hello codingpebble

with this settings it's only possible to add whole numbers:

I have it not tested, but maybe it's also possible with column validation:

https://support.microsoft.com/en-au/office/examples-of-common-formulas-in-lists-d81f5f21-2b4e-45ce-b170-bf7ebf6988b3?WT.mc_id=DX-MVP-5004845

Best, Dave

codingpebble

Copper Contributor

Dec 22, 2023

DaveMehr365

I think Im using the exact same settings.

However Im still able to add the same number in the column Fahrzeug.

You can add 1 then add 1.1 which is also displayed as 1

and 1.11 and so on