Custom sort date column which also includes text

Custom sort date column which also includes text

fredmalonefredmalone Posts: 2Questions: 1Answers: 0
edited August 2018 in Free community support

I have a column in my financial data table that primarily shows a date value. However, in some instances it may be necessary to show the word MEMO in that column instead of a date.

Is it possible to sort this column and treat the word MEMO as a far future date, which is in essence what it is?

Example:
(ascending)

10/10/2017
11/01/2017
MEMO
MEMO

(descending)
MEMO
MEMO
11/01/2017
10/10/2017

Thanks!

This question has an accepted answers - jump to answer

Answers

This discussion has been closed.