If cell from a different sheet equals todays date, show content from different sheet

I have a master sheet that has tons of data. I want to pull only data from two columns from a row if the data matches today's date.

I have tried the following:

=IF({sheet A column 1} = TODAY(), {Sheet A column 3}, "")

=INDEX({shhet A column 1}, MATCH(TODAY(), {Sheet A column 3}, '')

These are not working.

Can any one help?

Find more posts tagged with

Accepted answers

All comments

Genevieve P.

Hey @Nefe19

INDEX(MATCH is what I would suggest, although if there's any possibility that you may have more than 1 row that matches, try using JOIN(COLLECT instead:

=JOIN(COLLECT({sheet A column 1}, {Sheet A column 3}, TODAY()), ", ")

Where Column 1 is the value to bring back and Column 3 is the one with the dates to match.

See: Formula combinations for cross sheet references

If this hasn't helped, please post a screen capture of your two sheets, showing the formula error you're receiving (but block out sensitive data).

Thanks!

Genevieve

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.