Helper Column not being recognised as a date

Jack Parry

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?

SolutionSal

Hello, the function you're looking for is DATEONLY().

=DATEONLY([Assignment Due Date]@row)

Hope this helps!🙂

Jack Parry

Hi all,

I had to use the following formula:

=DATE(VALUE(MID([Assignment Due Date]@row, 7, 4)), VALUE(MID([Assignment Due Date]@row, 4, 2)), VALUE(IF(LEFT([Assignment Due Date]@row, 1) = "0", MID([Assignment Due Date]@row, 2, 1), LEFT([Assignment Due Date]@row, 2))))