How to display a date from the sheet

Hi everyone,

Does anyone have experience in making a date display in a date format within the Sheet Summary. I have tried to use ISDATE, DATE, and DATEONLY to no avail. I am creating the dashboard for this sheet. I want to display the Kick Off Call Date but I cannot get the date to display

These are my results

I want the actual date to display.

I also tried to just use =[Start Date]1 but got #Invalid Column Value


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!