Best Of

Hello @D Rowland

I think a MIN(COLLECT formula could be useful for you to return the earliest date for each [SO Number]. I have made a quick demo using the formula below.

The formula will return the earliest date from [Finished Date] where the SO number in the Data Sheet matches the [SO Number]@row in the look up/formula sheet.

=MIN(COLLECT({Data Sheet_Finished Date}, {Data Sheet_SO Number}, [SO Number]@row))

Data Sheet:

Look Up/Formula Sheet:

I hope that is helpful to you in some way,

Protonsponge

@AKalsi Does this video on using the Time() function help you any?

@Darren Mullen Thank you so much, that was exactly what I needed. Between that video and the one that played right after, I got what I needed. I pasted a link to the second video I was referencing. This was a big help!

Smartsheet Date Time Calculations: Calculating the Difference Between 2 Dates and Times

Hello @Elayne Smith

Try:

Start Date: =MIN(CHILDREN())

End Date: =MAX(CHILDREN())