I created a GROUPBY function for a string formula field in an earlier sheet. That formula is running without an errors according to the flip side.
However, the GROUPBY is showing an IllegalStateException for some values of the string field in the earlier sheet, but it's also showing the valid values.
Is there something I should be checking for to prevent this from happening? Happy to share the formulas and the workbook if that'll help.
Please sign in to leave a comment.