Report is Not Recognizing Date Column - Cannot Use a Filter

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.

Find more posts tagged with

Accepted answers

Joan Brewer

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!!

All comments

Paul Newcome

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?

Joan Brewer

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.

Joan Brewer

Joan Brewer

Thanks!!

Paul Newcome

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.

roconnellTFS

In case anyone else has this problem, what worked for me is adding a DATE( element to the function on the main sheet.

For example, this is the formula I used to pull the value below into a regular date format that Smartsheet Reports also recognize as a date :

Formula:

=IF(ISBLANK([Date Created]@row ), "", DATE(VALUE(MID([Date Created]@row , 1, 4)), VALUE(MID([Date Created]@row , 6, 2)), VALUE(MID([Date Created]@row , 9, 2))))

Original Value:

2024-11-13T21:42:48.877Z

Formula Populated Value:
11/13/24

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.