I am trying to find the next date in two columns of dates


Here is the formula I am using

=MIN((COLLECT[Start Date]1:[End Date]25),@cell > TODAY())

I will take this cell and copy it to a master sheet


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!