Need MAX Date, and MAX Time, for specific Location

SkiPatrolScott ✭✭✭✭
edited 01/26/23 in Formulas and Functions

I need to be able to parse out an entry based on Latest Entry, most often this entry will have an open and close., sometimes multiple times a day. I want to be able to have a separate sheet that displays the most recent event. Thought I had it, but realized the sheet stopped at the first MAX date and did not reference the most recent entry. Created a formula to take the DATE field and display as 230125 and then added the TIME so the final looks like 2301250825, works great to sort but am getting a "0" any time I try to find a max value. Is it because it is a Formula? note in the example below I did have +"-"+ between date and time.

The formula did work to pull the most recent date, its just that this Run was opened at 1107 and the formula did not decipher that....

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!