Oldest date in a column

Bret Plemons

I'm trying to do a Sheet Summary formula to give me the date of the oldest call on a service sheet. I am trying to use =MIN(Date Entered) Also tried =MIN([Date Entered]). Nothing is working. The formula seems simple but nothing I am doing works.

Jeff Reisman

Your summary field must also be a Date field:

Jeff Reisman

https://community.smartsheet.com/discussion/87218/oldest-date-in-a-column

You need to give the function a column range to work with, not just the column name.

=MIN([Date Entered]:[Date Entered])

Make sure your "Date Entered" column is formatted as a date-type column. If there's a date value in it, it needs to be a date-type column to use the MIN/MAX functions on it.

Bret Plemons

I had tried that before as well but it didn't work. Here is what I have currently.

=MIN([Date Entered]:[Date Entered])

Jeff Reisman

Your summary field must also be a Date field:

Bret Plemons

Ok, that was the problem! Thank you!