Forumula to pull oldest date in a column

I am trying to pull the oldest date into into a dashboard.  I have my metrics sheet and keep getting the #invalid Column value error.  I am using the MIN forumula and referencing the column on my sheet.                               =MIN({Depot Repair Collection Log Range 1})

Any clues or anyone have a sample formula I should be using.  I made sure the column on my sheet was set as a date column

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!