Find "soonest" or closest date in a column of dates.


I'd like to find the earliest or Next available date for 3D Printing Dashboard. I'd like to use IF or IFS given that I would like to search only rows with a "Printing" Status.

There are no formulas that seem to help.

Any help would be appreciated



  • ataberk_teknekaya

    Hi RPIArchShop!

    Lets say your sheet is something like this,

    You can create a report and add that report to a dashboard

    Filter the status to printing and sort the due date the oldest to newest. By this way, you can find the closest order.

    I hope it helps :)

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!