The result field Formula (Text) cannot be grouped. Please edit the search and omit this field or use a different summary function.-CarlZeng

The result field Formula (Text) cannot be grouped. Please edit the search and omit this field or use a different summary function.

Solution:

  1. Create a drop down Custom List, I.e. Yes, No as the two options
  2. Create a new field in the record type(as an example), and link to above new dropdown/select field
  3. Use UE to set/sync value for new field to heal the data of Yes, No option value.
  4. Update the Saved Search to Group on new select/drop down field. (it will not trigger: The result field Formula (Text) cannot be grouped…. The result field Formula (Numeric) cannot be grouped….. )