I have, for the last few years, used a field called "Enabled" and a calculated field which returns the value of the Title field if Enabled is true. If Enabled is false, it returns an empty string (""). This is the formula for that field:


This allows the administrators of the site to temporarily enable/disable options from displaying in the new and edit form of a list which references those items in a multiple-choice lookup column with out-of-the-box functionality instead of using code. This has worked for many years, but all of a sudden, after the user-facing list (not the lookup list) has had thousands and thousands of items, this is causing issues.

On the display form, the disabled items in a lookup field used to not appear while the enabled items would still show. Now, the disabled items are displayed as numbers showing the corresponding lookup ID.

On the edit form, if a user had previously selected an item in a lookup and that item has now been disabled (blank), the item would fall off the list of selected results and not be available in the list of selections. Now, the entire selection candidate and results for the lookup field are not rendered. I inspected the HTML for the form, and there is literally nothing on that row other than the initial table cell with the field name.

This type of functionality (blanking out a field used in a lookup selection in order to hide it) still works on other lists and other sites. How can I narrow down what it suddenly causing this issue on this one list?

  • Anyone changed the lookup column settings recently? – Alex Filipovici Nov 8 '18 at 11:19
  • No, and this issue is happening on 10 lookup fields that use the same logic on this list. The control appears again if I change the formula to a single space instead of empty, but this actually displays empty values for the ones which were previously hidden. – Dinerdo Nov 8 '18 at 15:09
  • Anyone changed the Regional Settings? – Alex Filipovici Nov 9 '18 at 15:59
  • No, they have not changed. – Dinerdo Nov 9 '18 at 17:29

Your Answer

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

Browse other questions tagged or ask your own question.