Generate Document Automation - Time Stamp

I have a Smartsheet where I leverage the created date column type.

I use the generate documents feature to generate a PDF. I have this Request Date field mapped to one of PDF Form field; however, when the PDF is populated, it doesnt use the 10:59am time, it goes with a time 6 hours ahead.

Anyone else experienced this and know a trick to getting the time to print based on the sheet. I have my timezone in my profile settings set and 10:59am is the right time based on my time zone settings. Cant get a formula to work to just populate this as a string because of the invalid column type and then a date column doesnt support the time.

Just curious what people in a similar situation have done to get around this Smartsheet limitation?

Thanks!

Find more posts tagged with

pdf viewer

Accepted answers

All comments

Michelle Choate 2

So the problem here is that the system column is showing you the time in your timezone, however the column is in UTC, so when it imprints in Document Builder, it is imprinting the hard coded information. There are lots of discussions in the community previously from folks who have had this exact same issue.

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.