Group Sorting Issue (Bug?)

[Kem_Ave]

Hi is there an issue with the group sorting logic?
It seems to be behaving the opposite for my virtual column [isCertified] (“Pending”, “Certified”). It’s a “Yes/No” type column, with Pending for FALSE, and Certified for TRUE.

Here is when I set it to “Ascending”.

And here is when it’s set to descending.

They’re behaving the opposite of the expected way.

Not sure if this applies only to the very first level of grouping/sorting.

Or appsheet is sorting it by FALSE –> TRUE when ascending, hence PENDING –> CERTIFIED?

[Suvrutt_Gurjar]

@Kem_Ave

Or appsheet is sorting it by FALSE –> TRUE when ascending, hence PENDING –> CERTIFIED?

I believe your assumption is correct. The sorting gets applied on the “ actual” field value rather than the “display” value.

I believe this is an edge case. In case of Y/N columns, display values were introduced a few years ago. However sorting is based on actual values like all other columns.

[Kem_Ave]

Ah yes… in this case, PENDING and CERTIFIED are just display values.
I understand. Thanks ^^