Return value as per date
I need to have the all the return value from column 209 if the End Date goes beyond a certain date at end of month like Nov 30 ,2021. The return value is on a different sheet. What is the best approach.
Thanks
Best Answer
-
The formula works and I will be looking into the create report to see which is best. Thanks
Answers
-
Hi @Mary Kam
You could use a JOIN(COLLECT formula to bring together into one cell any of the values in Column 209 where the date is older than a specified day, like so:
=JOIN(COLLECT({Column 209}, {End Date Column}, @cell > DATE(2021, 11, 30)), ", ")
This would bring back two values from your screen capture above into one cell, like so:
x500-125, x700-139
See: JOIN Function / COLLECT Function / Cross-sheet formulas
Is this what you were looking to do? Another option would be to create a Report so you can see all the rows that match your criteria along with any relevant columns.
Cheers,
Genevieve
Join us for Jumpstart 2025 with Community on 23 January (in two time zones)! 🎉 Register here.
-
The formula works and I will be looking into the create report to see which is best. Thanks
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!