Formula to Determine NEXT DATE from a group of Dates

I Have a series of Go Live Date columns in a Smartsheet and I want a new column called "Next Date" that determines which of the dates is the next Go Live date. I using the following formula but it doesn't return any value:

=MIN(COLLECT([Release 1 Go Live]@row, [Release 2 Go Live]@row, [Release 3 Go Live]@row, [Release 4 Go Live]@row, [TA Go Live Date]@row, [PCS Go Live Date]@row, [TM Go Live Date]@row, [TF Go Live Date]@row, [JIE Go Live Date]@row, [WFEX Go Live Date]@row, >=TODAY()))

Tags:

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!