Discussions
SuiteWorld brings thousands of innovators, builders, and leaders together to learn, connect, and shape what’s next. This October, explore how to build a stronger foundation for growth through inspiring keynotes, major product reveals, hands-on sessions, and unforgettable moments—all in one place for our biggest event of the year. Join us
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