Collect and display nearest dates
Options
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.
Tags:
Comments
-
Is your [Next Due Date] column set as a date type?
-
Exactly what I wanted. It worked for me.
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!