Collecting earliest date based on certain criteria

Jonathon Woodall

Jonathon Woodall ✭✭

01/11/22 in Formulas and Functions

Does anyone know the formula to search a column and return the either the earliest or latest date?

or latest date.

0 ·

Best Answer

SoS | Dan Palenchar Community Champion

01/11/22 Answer ✓

MIN() and MAX() do this
https://help.smartsheet.com/function/min
https://help.smartsheet.com/function/max

School of Sheets (Smartsheet Partner)
If my answer helped please accept and react w/💡Insightful, ⬆️ Vote Up, ❤️Awesome!
0 · Share on Facebook Share on Twitter

Answers

SoS | Dan Palenchar Community Champion

01/11/22 Answer ✓

MIN() and MAX() do this
https://help.smartsheet.com/function/min
https://help.smartsheet.com/function/max

School of Sheets (Smartsheet Partner)
If my answer helped please accept and react w/💡Insightful, ⬆️ Vote Up, ❤️Awesome!
0 · Share on Facebook Share on Twitter
Jonathon Woodall ✭✭

01/11/22

Thank you really appreciate your quick response - Jonathon.

0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Percent for activities 100% completed and for ongoing activities and for not started activities
Can anyone please help me with this How i can get a percent of the activities that are 100% completed, and a percent of the activities that are ongoing and for the not yet started activities. the total of three figures is 100% of the project. I hope that I explained it correctly, and thank you in advance.
Checking multiple sheets for duplicates
Hi, I have a workspace that is being used for uploading new information by a group of techs. This information is checked and then uploaded a database by another team. Currently, I have the sheet working to check duplicates within one sheet, but once the data is uploaded to the database the line is moved to another…
Can you create email notifications on several different cells in a single column
Good morning, My project team asked me to create an inventory smartsheet. They are requesting email notifications for a single column, but for different inventory amounts on each cell. Is this possible??