Multiple columns sorting with "date" column using an array function rather than sort.

[DexterStagg]

Hi,

I am creating a job planner that sorts jobs by oldest date and then has further columns to track the status of the job such as quoted, repaired etc. The jobs are inputted in one table and sorted in a second, the second is where the status columns are located. I beleive that this may not be able to work as a value and formula are required in the same cell.

Thank you for taking the time to look at my sample sheet attached.

Dexter

[AliGW]

As you will no doubt want help with this, and not just opinions via a vote, I have closed the unnecessary poll.

[Gregb11]

Well, I can think of 2 options, but neither does exactly what you want unfortunately.

1. Put the status columns on the unsorted table and update them there, and add them into the sorted table with the formulas like you have for jobs. My assumption is that it will be harder for you to update the statuses as time goes on because it'll be harder to find them in a long, unsorted list.

2. Just use one table with all information, and whenever you need to update the table, sort the table by date. (I would put it in an "Excel Table" as this should make it easy to sort)

Sorry, that's the best I can come up with. (Option 2 should work pretty well though).