Notion Database Cannot Reorder Columns: Workaround

You are trying to drag a column in a Notion database view to a new position, but the column will not move. The drag action either does nothing, snaps the column back to its original spot, or reorders the wrong column. This limitation occurs because Notion restricts column reordering in certain database views, specifically in Table view when the database has linked databases or complex properties. This article explains why column reordering fails and provides the only reliable workaround to achieve the column order you want.

Why Notion Does Not Allow Column Reordering in Some Views

Notion uses a block-based architecture where each database property is stored as an independent block. Column order in a Table view is determined by the sequence in which those property blocks were created. When you drag a column, Notion attempts to reorder the underlying property blocks. However, this operation fails when a property is referenced by other properties through formulas, rollups, or relations. The database engine cannot reorder a property block without breaking the reference chain.

This limitation affects all database views: Table, Board, Gallery, List, Calendar, and Timeline. The drag-and-drop behavior appears to work in some views but actually only changes the display order of cards or items, not the column order itself. In Table view, the column header is the only place where you can attempt to reorder columns, and it fails silently when references exist.

Properties That Block Column Reordering

The following property types, when present in a database, prevent column reordering:

• Formula — references other properties by name, and reordering breaks the reference
• Rollup — depends on a Relation property and a specific property in the related database
• Relation — links to another database, and the link is stored as a property block
• Created time / Created by — system properties that are locked
• Last edited time / Last edited by — system properties that are locked

Steps to Reorder Columns When Drag-and-Drop Fails

The only reliable workaround is to remove the problematic columns and add them back in the correct order. This process preserves all data if you follow the steps carefully.

1. Identify the columns that block reordering
   Open the database in Table view. Try to drag one column at a time to a new position. The columns that snap back are the ones causing the limitation. Note their names and their current positions.
2. Add new placeholder columns at the target positions
   Click the + button in the last column header to add a new property. Give it a temporary name like Temp1. Add as many temporary columns as you need to match the number of columns you want to reorder. These placeholders will hold the data while you rebuild the order.
3. Copy data from the blocking columns to the temporary columns
   For each blocking column, select all cells in that column. You can click the column header to select the entire column. Press Ctrl+C to copy. Click the header of the corresponding temporary column. Press Ctrl+V to paste. Notion pastes the values, including text, numbers, dates, and select options. Formulas and rollups will not paste directly — you must recreate those formulas manually.
4. Delete the original blocking columns
   Click the arrow in the header of the original blocking column. Select Delete property. Confirm the deletion. The temporary column now holds the data. Repeat for each blocking column.
5. Rename the temporary columns to the original names
   Click the header of each temporary column. Select Rename property. Type the original column name. Press Enter.
6. Reorder the renamed columns using drag-and-drop
   Now that no references exist, you can drag the renamed columns to any position. Hold the left mouse button on the column header and drag left or right. Release when the blue indicator line appears at the desired position.

Alternative Workaround: Use a Board View to Simulate Column Order

If you do not need to change the actual property order but only want to display columns in a different sequence, create a Board view grouped by a Select property. This method changes the visual grouping but does not reorder the underlying columns in Table view. It works best for databases with a small number of groups.

If Notion Still Refuses to Reorder Columns

Column Header Shows a Lock Icon

Some columns are locked because they are system properties. Created time, Created by, Last edited time, and Last edited by cannot be reordered or deleted. To work around this, create a Formula property that duplicates the value of the locked property. For example, to reorder a Created time column, add a Formula property with the formula formatDate(prop("Created time"), "MMM D, YYYY"). Then hide the original Created time column by clicking the column header and selecting Hide. The new Formula column can be reordered.

Columns Keep Snapping Back After Deleting References

A Formula or Rollup column may reference a property that itself references another property. This creates a chain of dependencies. You must delete all dependent columns in the correct order — start with the formulas that depend on other formulas, then delete the intermediate formulas, and finally delete the base property. Use the temporary column method described above for each dependent column.

Database Has More Than 100 Properties

Notion limits the number of properties in a single database to 100. If you have reached this limit, you cannot add temporary columns. In this case, you must delete unused properties first. Click the database title, select Properties, and remove any properties that are not actively used. Then proceed with the temporary column method.

Notion Database Views: Column Reorder Capability Compared

View Type	Column Reorder Supported	Limitations
Table	Yes, with restrictions	Fails when Formula, Rollup, or Relation properties exist
Board	No	Columns are groups; you cannot reorder property columns
Gallery	No	Property order is fixed based on the Table view order
List	No	Property order is fixed based on the Table view order
Calendar	No	Property order is fixed based on the Table view order
Timeline	No	Property order is fixed based on the Table view order

Only the Table view allows column reordering, and even then only when no Formula, Rollup, Relation, or system properties are present. All other views inherit the column order from the Table view. If you reorder columns in Table view, the change applies to all views that display those columns.

You can now reorder columns in any Notion database by removing blocking properties and adding them back in the desired sequence. Use the temporary column method to preserve your data. To avoid this problem in future databases, create properties in the order you want them to appear from the start. For databases with many formulas, consider grouping related formulas into a single property using the concat() function to reduce the number of dependent columns.