Collect and display nearest dates

Elliot Holder
Elliot Holder ✭✭
edited 12/09/19 in Formulas and Functions

I have a job tracker designed to track the art components of our jobs. We would like to have a column display the next nearest due date for that row. My trouble is we may have 1-10 due dates on a given row and there are non-date columns between each of the due date columns. I'm fairly sure I need to use a MIN(COLLECT( type formula, but not sure how to arrange it. Screen shot below w/ pertinent columns circled.

NextDateExample.JPG

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!