When you try to reorder rows in a Notion database by dragging them, the rows may snap back to their original position or simply not move at all. This usually happens when the database view has an active sort applied. The drag-and-drop feature is designed to let you manually arrange items, but a sort rule overrides any manual row order. This article explains exactly why the conflict occurs and shows you how to re-enable drag-and-drop reordering by managing sort states correctly.
Key Takeaways: Fixing Drag-and-Drop Reordering in Notion Databases
- View sort button (column header drop-down > Sort): An active sort locks row order and disables manual drag-and-drop.
- View > Sort > Remove all sorts: Clearing every sort rule restores the manual row order mode.
- Grouped view with sort: Drag-and-drop works only within each group; moving a row between groups requires changing group values.
Why Sort Rules Block Manual Row Reordering
Notion databases can display rows in two distinct ordering modes: manual order and sorted order. When you first create a database, rows appear in the order you add them. You can then drag any row to a new position, and Notion records that custom order. This is manual order mode.
When you apply a sort rule — for example, sorting by a date column in descending order — Notion switches to sorted order mode. In this mode, the database engine continuously calculates the position of each row based on the sort criteria. Because the sort is dynamic, there is no fixed row index for you to drag a row into. The drag action is blocked because the system would have to both keep the sort and accept a manual position, which is logically impossible. Notion chooses to disable the drag gesture entirely when any sort is active.
The same restriction applies when you use a filtered view that also has a sort. Even if the filter narrows the visible rows, the sort still overrides manual order. Grouped views behave slightly differently: you can drag rows within a group, but you cannot drag a row from one group to another unless you change the value of the group-by property.
Steps to Restore Drag-and-Drop Reordering
- Identify the active sort
Look at the top of the database view. If you see a column header with an arrow icon or the word “Sort” displayed next to a filter icon, a sort rule is active. Click the “Sort” button to open the sort panel. - Remove all sort rules
In the sort panel, click the “X” next to each sort rule to delete it. If there are multiple rules, remove every one of them. The view will immediately revert to manual order mode. - Test the drag-and-drop gesture
Click and hold the six-dot icon at the left edge of any row. Drag the row to a new position between two other rows. Release the mouse button. The row should stay in the new position. - (Optional) Reapply the sort after manual ordering
If you need the sorted view back, first finish all manual reordering. Then add the sort rule again. Your manual order is lost once the sort is reapplied, because the sort recalculates all positions.
If Drag-and-Drop Still Fails After Removing Sort
Rows snap back when the view is grouped
In a grouped view, you can drag a row only within its current group. If you try to drag the row into another group, it snaps back. To move a row to a different group, edit the property that defines the group. For example, if the view is grouped by “Status,” change the row’s status to the target group value. The row will move automatically.
“Can’t move row” error appears on a linked database
When you use a linked database view that references a source database, drag-and-drop reordering may be disabled if the source database has a sort rule. Open the source database, remove the sort, and then return to the linked view. The linked view will inherit the manual order from the source.
Drag icon does not appear on rows
If the six-dot drag icon is missing entirely, the view might be in a locked layout. Check the view settings by clicking the view name at the top of the database. Ensure that “Lock view” is not enabled. If it is, click “Unlock view” to restore the drag icon.
Notion Database Sort Mode vs Manual Order Mode
| Item | Sort Mode | Manual Order Mode |
|---|---|---|
| Row order | Determined by sort criteria (date, number, etc) | Determined by user drag-and-drop position |
| Drag-and-drop reordering | Disabled | Enabled |
| Sort rules visible | Yes — shown in the view header | No sort rules present |
| Best use case | Data analysis, priority lists, timeline views | Custom sequencing, Kanban swimlane order, meeting agendas |
| How to activate | Add a sort rule from the column header menu | Remove all sort rules from the view settings |
You can now distinguish between a sorted view and a manually ordered view in Notion. Before you attempt to drag rows, check the view header for any active sort rules. If you need both a custom row order and a specific sort, consider using a separate property like “Order” with numbers and sorting by that property instead. This approach gives you a sortable numeric column while keeping drag-and-drop disabled. For most workflows, the simplest fix is to remove the sort, rearrange rows, and then reapply the sort only when you no longer need manual ordering.