Forum Discussion

codingpebble's avatar
codingpebble
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's avatar
    codingpebble
    Dec 22, 2023
    I solved this using validation:
    =IF([Number Column] = ROUND([Number Column], 0), true, false)
codingpebble's avatar
codingpebble
Copper Contributor
Dec 22, 2023
I solved this using validation:
=IF([Number Column] = ROUND([Number Column], 0), true, false)

Resources