I'm using SharePoint 2010. I had a number column set to require a unique entry with a minimum value of 5000. After about 40 entries were made to the list the minimum value requirement was changed to 3000. Editing pre-existing entries to change the value to a number under 5000 errors out with a message "Only values greater than or equal to 5000 are allowed." Is it possible to retro-fit this change to the existing list entries so I can modify the values - without using coding?
You could just bulk edit the columns in the page using the quick edit feature in the toolbar for the list.
The SharePoint Management Shell commands can be used to update the minimum value. Change the site url, list and column names.
$web = Get-SPWeb("site_url") $list = $web.Lists["list_name"] $field= $list.Fields["column_name"] $field.MinimumValue = 3000 $field.update()
Hope that helps.