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.
Your summary field must also be a Date field:
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
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.
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
I had tried that before as well but it didn't work. Here is what I have currently.
=MIN([Date Entered]:[Date Entered])
Your summary field must also be a Date field:
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
Ok, that was the problem! Thank you!
