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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!