Discussions
Unstored text field shows incorrect value in list view
Here is my basic setup:
Custom Item Fields:
6 checkbox fields (all values stored)
1 Text field (unstored formula)
The formula on the text field is set so that when any of the 6 checkboxes are unchecked, the text field evaluates to "No". If all 6 are checked, it evaluates to "Yes".
This is working perfectly except for one issue. When viewing the Text field in a list (such as as search result), every single item evaluates to "No", even though most of them should be "Yes". When I click on any item, it's individual record correctly shows "Yes" when it should be, and "No" when it should be, but the list view refuses to budge. In order to get the list to show the correct result, a formula field must be added instead, and the correct value must be calculated off the value of the checkbox fields again. Obviously not the