Custom sort orders?

[wjkelly]

I have a calculated column called brand_status that calculates a store's engagement with a brand based on recent order behavior.

The statuses are "Activated" "In Activation" "Needs Reactivation" "Sampled"

Is there a way to define the sort order for these items so that I could sort the records based on something other than alpha or numeric?

---

Operating system used: MacOS Monterey v12.4

[anino]

Hi,

I don't think there's a direct way to do that, however, you can use Switch case processor to set a numeric value in a new column for any possible value ("Activated" "In Activation" "Needs Reactivation" "Sampled").

Once you have all possible values configured, you can use this new column as sort column.

BR,

Álvaro