Collecting earliest date based on certain criteria
Options
Does anyone know the formula to search a column and return the either the earliest or latest date?
or latest date.
Best Answer
-
MIN() and MAX() do this
School of Sheets (Smartsheet Partner)
If my answer helped please accept and react w/💡Insightful, ⬆️ Vote Up, ❤️Awesome!
Answers
-
MIN() and MAX() do this
School of Sheets (Smartsheet Partner)
If my answer helped please accept and react w/💡Insightful, ⬆️ Vote Up, ❤️Awesome!
-
Thank you really appreciate your quick response - Jonathon.
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!