ENUM Sorting

[Steve_Fuller]

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

[WillowMobileSys]

Steve_Fuller:

What am I doing wrong?

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.

[Steve_Fuller]

Hi. Thank you for replying.

The column is in the same table.

I’ll try your suggestion