Possibility to sort data by status

NotionApps Roadmap
1

Good evening, I do not know if this function already exists: I would need to sort the data by STAUS and not only alphabetically.
Basically I have data with the following steps: “To start”; “in progress”, “completed” and “Blocked”.
I have to order them in order of process:

  1. To be started
  2. Ongoing
  3. Stuck
  4. Completed

Using the alphabetical order I find that the locked items are shown first (in italian “Bloccato”).
I hope that I have been clear and that I will receive feedback on this.
Thank you in advance.

2

Hi, @Paolo_Cesareo. You could create a formula that assigns numbers 1, 2, 3, & 4 based on the status and then use this new formula column to sort the data.

3

Interesting tip!
I have to try and let you know.
Thank you

4

This request is covered by a workaround, and it is on the roadmap as live.

Problem

A status property should sort in process order: to start, then in progress, then blocked, then completed. Alphabetical sort puts blocked first and completed next, which is the wrong queue.

Why this is a workaround

The list sorts by a property’s value. A select’s option order in Notion is not a numeric sort key the list can use. A formula that maps each status to 1, 2, 3, and 4 is a normal number, and the list can sort on it. That formula is the order. A native “sort by the order I arranged the options” control is a different request and is not what closes this one.

How to use it

  1. In Notion, on the database, add a formula property. Name it Sort order.
  2. Map each status to a number, using the option names exactly as they are spelled in Notion. For the four-step queue:
if(prop("Status") == "To start", 1, if(prop("Status") == "In progress", 2, if(prop("Status") == "Blocked", 3, 4)))
  1. The last number is the fallback for Completed, and for any status you did not name. Give every status its own number if the fallback would land in the wrong place.
  2. Check a few rows in Notion. To start shows 1, In progress shows 2, Blocked shows 3, Completed shows 4.
  3. In NotionApps, reload the database so Sort order appears.
  4. Open the list screen in the builder. Click + Add Sorting. Choose Sort order, ascending, so 1 is at the top.
  5. Remove an older alphabetical sort on Status if it is still there, or put Sort order ahead of it.
  6. Publish.
  7. Confirm the list runs to start, then in progress, then blocked, then completed.
  8. When you add a status later, edit the formula, reload, and check the new number.

Use the same formula on every list that should share this order. Each screen has its own sort, so add Sort order on each of those screens.

Documentation