Index & Collect Using Date Range

Hello,

I'm trying to return cell values from another sheet based on a date range in a date field but I can't seem to get the formula to work.

In a new sheet, I want to return the value of a specific cell from a different sheet based on the date range (3 months prior to today) field. This is what I tried and it doesn't seem to work. I'm also open to any other suggestions.

I tried (today)-90 but that didn't return any values

=INDEX(COLLECT({OSS Test Range 3}, {OSS Test Range 2}, <DATE(2022, 4, 1)), 1)

Find more posts tagged with

Formulas

Cell linking

Accepted answers

All comments

Jeff Reisman

@Kaykay Double check that the column you are referencing with {OSS Test Range 2} is really formatted as a date column. If it is actually a text/number column filled with date values, you cannot perform date calculations or comparisons against it.

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.