Sorting an Indexed Date
I am pulling a date into my dashboard using an index and Match formula. When I go to sort the data, it sorts the date from left to right so 1/2/23 is before 1/3/22. I thought I might need helper columns to break the date out into month, day and year columns and sort on year then month then day. I get invalid data error when I do that. I assume it is reading it as text even though the column is date only. What can I do to either bring them in as dates or convert them to something I can sort?
Help Article Resources
Check out the Formula Handbook template!