Next Payment Due
Using MIN COLLECT to select from dates the next payment due date. Nothing is being returned. I can't figure out what I am doing wrong. Next step would be to select the value associate with the date.
=MIN(COLLECT([Year 1 Due]1, [Year 2 Due]1, [Year 3 Due]1, [Year 4 Due]1, [Year 5 Due]1, [Year 6 Due]1, <TODAY()))
Best Answers
-
Are all of those columns next to each other? If so, try this...
=MIN(COLLECT([Year 1 Due]@row:[Year 6 Due]@row, [Year 1 Due]@row:[Year 6 Due]@row, @cell < TODAY()))
-
Thank You. Solved! Your help is greatly appreciated!
Answers
-
Are all of those columns next to each other? If so, try this...
=MIN(COLLECT([Year 1 Due]@row:[Year 6 Due]@row, [Year 1 Due]@row:[Year 6 Due]@row, @cell < TODAY()))
-
Thank You. Solved! Your help is greatly appreciated!
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!