Moving columns around is really simple when using defined Tables!

Select whole column (click on column label at top of page, eg. G for DueDate column);
Holding down Shift key, place mouse cursor over either of column left or right borders (crossed arrows are displayed), press down left key, and drag the column to new location (formula(s) in moved column remain unchanged);
Release mouse key and Shift key.



To add new column (e.g. SentForReview), simply insert a new column into wanted position, and then edit column header. After that:
1. you can enter formula into new column, when this is meant for this column;
2. you can enter values into new column, when this is meant for this column;
3. you can edit existing formulas in other columns to take into account added column.

I moved DueDate and added SentForReview columns. And I edited formulas in other columns so they can cope with empty rows in Table.

Attached Files

DueDate-test (1).xlsx (32.5 KB, 9 views)