ENUM Sorting

What am I doing wrong?

If I put this code SORT(Cost Book[Category]) in Valid_if the Enum list is sorted BUT I cannot add to it

If I put the code in a Suggested_Values it allows additions BUT is not sorted

Is the Category column you are trying to configure the one in the Cost Book table?

My guess is no. If so…

Notice that there are a couple extra values in the example from when it is placed into Suggested_Values. I believe these are “other” values currently listed in the column that do not exist in the Cost Book[Category] list of values. So, I think, what is happening is the Cost Book list is sorted and added then the “other” values are tacked on.

3 Likes

Hi. Thank you for replying.

The column is in the same table.

I’ll try your suggestion

1 Like