Custom Sorting a column by Date....and Text

I need to custom sort a column. I have 3 different types of data in the column.
First - multiple dates, Second - "TBA", and Third - "ASAP". What I need is when the column is sorted the "ASAP" rows will be first, the dates (sorted) will be next and finally the "TBA"s. I have been trying to use a custom list.....? Does anyone have any ideas? Thank You

Hi Khaos,

One option might be to use a helper column. For example, let's assume your "assorted data" column is A and you have other columns of values (irrelevent). Headers are in row 1 and data starts in row 2.

In an open column (let's say D), in row 1 (D1) put a header (e.g. "Sort ID") and in row 2 (D2) put the formula:

=IF(A2="TBA",2,IF(A2="ASAP",3,1))

Fill that down column D for as many rows as you have in column A. This will result in a bunch of 1's, 2's and 3's based on the value in column A. Select your whole data range now, and in the sorting options set your first sort to be on the new column (D) ascending, and your second sort criteria on your original "assorted data" column (A).

Hopefully that helps!