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?
Answers
-
You are going to need to go back to the source data. It sounds like the source data is a text value. Making sure those are actual dates stored in a date type column should fix the issue.
-
I think that once data is pulled from the source and it is twice removed, it becomes text. I have individual schedules on separate smartsheets. Then I have a sheet that consolidates all of that. If I then pull that data to another sheet, it becomes text. So I have create a copy of the second sheet and reduced it to the data I need and added the data I produce to that sheet.
-
@PL123 It depends on how exactly you are pulling the data. I have pulled data across numerous sheets and still maintained the data type.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!