Report is Not Recognizing Date Column - Cannot Use a Filter
![Joan Brewer](https://us.v-cdn.net/6031209/uploads/avatarstock/nY444VT9FTI6D.png)
Hello! I am trying to create a report that filters based on a date from a sheet. The report is not recognizing the source sheet column as a date column, so when I create a filter based on the date, nothing appears. I validated that it is not recognizing the source column by filtering by "is a date", as well as many of the other date filters.
I have tried making a new date column in the source sheet to see if it was something with the original one, but it still does not work on the column.
Best Answer
-
I figured it out. The sheet the formula was pulling from did not have the Date column set as a 'Date Column Type'. Once I changed that, the sheet I was working on was able to recognize that column data as Dates. Then the report worked.
Thanks!!
Answers
-
Have you confirmed the column in the source sheet is in fact set as a date type column? If so, how exactly is that column being populated?
-
Hi Paul,
Yes the column is confirmed a date column. It is being populated by an INDEX(MATCH()) formula that is pulling the date from another sheet.
-
I figured it out. The sheet the formula was pulling from did not have the Date column set as a 'Date Column Type'. Once I changed that, the sheet I was working on was able to recognize that column data as Dates. Then the report worked.
Thanks!!
-
Happy to help. 👍️
Glad you were able to get it sorted. That was going to be one of my questions once I read that it was coming from another sheet.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 351 Global Discussions
- 198 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 36 Webinars
- 7.3K Forum Archives