I have a list that has a dropdown box as one of its columns. We changed the values in the dropdown box and now some of the items in the list refuse to allow us to blank out that column (so it has no value), the dropdown box doesn't show the blank value as an option and requires one of the items to be there. Is there any way to fix this other than to blow away the column and start from scratch?
The only way to create an option to set a list to [blank] is to put a non-printing character in the list of choices and have that be the default to avoid having 2 blank choices at the top for a new item. This allows you to set an item to [blank] and I believe it still functions for the sorting/filtering options of a list. I had an example of one I used, but I can't seem to find the code anywhere. I pasted it in between these quotes, but I am not sure if it will translate over. " " Regular and non-breaking spaces will not work.
Edit: Here is the original answer that I found it in. How to Add Blank to choice field?
Here is one way I found to do it:
- In the Additional Column Settings section, set
Require that this column contains informationto No, set
Allow 'Fill-in' choicesto Yes.
You should then be able to edit the data element containing the column and choose Fill-in rather than any of the drop-down options but leave the fill-in box blank. This will wipe out the previous data value.
In my case I normally DON'T want to allow fill-ins so I then just switched the
Allow 'Fill-in' choices back to No and everything is as I wanted it.
New data elements would allow blank data or the choices from the dropdown as it always did without having to screw around with phony or non-printing characters and the data I wanted blanked out was gone.
Not sure if this will fulfill business part of your requirement, but a column in a SharePoint list can be optional or required. If you set it to be optional (not required) you will be able to leave it empty.