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?
Answers
-
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
Need more information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!