Helper Column not being recognised as a date

Hi, I'm using Data Shuffle to import a report generated from another system into an excel sheet into Smartsheets.

However, on the date on the report also has a time stamp. Which Smartsheets doesn't like, so I've used a helper column to generate the date without the time stamp.

By using the following formula:

=LEFT([Assignment Due Date]@row, 10)

The column is set to Date and restricted to only dates, but conditional formatting refuses to see it as a date? Any advice?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!