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?

Find more posts tagged with

Accepted answers

All comments

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))))

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.