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

0 2 123
2 REPLIES 2

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.

Hi. Thank you for replying.

The column is in the same table.

Iโ€™ll try your suggestion

Top Labels in this Space