Formula Help

JennyB.

Hi,

I am trying to find a formula that finds the closest project board date following a milestone date. From the screen shot below I want to look at the dates in the second column and find the next board date from the cell highlighted in the finish column. Is there a way smartsheet can do this or will I have to do it manually?

Paul Newcome

Try:

=MIN(COLLECT([Project Board Dates]:[Project Board Dates], [Project Board Dates]:[Project Board Dates], @cell> Finish Date]@row))

Paul Newcome

Try:

=MIN(COLLECT([Project Board Dates]:[Project Board Dates], [Project Board Dates]:[Project Board Dates], @cell> Finish Date]@row))

JennyB.

That works! Thank you so much

Paul Newcome

Happy to help. 👍️