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

Monica Ladd

Here is the formula I am using

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

Screenshot 2024-05-07 135955.png

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

Screenshot 2024-05-07 140130.png

James Keuning

=MIN(COLLECT([Start Date]:[End Date], [Start Date]:[End Date], >TODAY()))

How is the record in your second table related to the first table? How does Smartsheet know what cell to put the date in?

IEPE

Hola, te falta el rango de criterio de busqueda en la formula:

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

ejemplo.png

espero eso sea lo que buscabas. saludos.