Date and Time issue - Calendly>Zapier>Smartsheet

can'tHi

I have people booking times with my company via calendly>zapier>smartsheet. However, the date and time arriving in the smartsheet cells is appearing as eg 2025-11-25T05:00:00.000000Z. I cant get this to change without it becoming UNPARSABLE. I have tried some standard formulas that AI is suggesting to no avail. Can anyone suggest a fix for me, please? I understand zapier can convert this but i would prefer all the formulas and control to be within smartsheet.

If this isn't possible, then I will resort to the Zapier fix.

Thanks for your help - John

Find more posts tagged with

Formulas

functionality

Accepted answers

All comments

GuruCharan Tanneeru

Hi,
Try this workaround:

Let’s say you have a column named “Text Date” with values like 2025-11-25T05:00:00.000000Z.

Create a new Date column and use the following column formula:

=DATE (VALUE (LEFT([Text Date]@row, 4)), VALUE (RIGHT(LEFT([Text Date]@row, 7), 2)), VALUE(RIGHT (LEFT([Text Date]@row, 10), 2)))

This formula extracts the year, month, and day from the text value and converts it into a proper date format.

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.