Formulas are working in the grid but not on the cross reference

Has anyone had this issue before? I'm using a formula to extract the created time from the system generated crated time stamp using the formula below.

=RIGHT(Created@row, FIND(" ", Created@row, 1) - 1)

The time stamp is working well in the sheet but is adding a comma to the output when I try to cross reference it in another grid. Is there a better formula I should be using or another way to get timestamps to help determine peak hours throughout the day?

1Capture.PNG

2Capture.PNG

Find more posts tagged with

Formulas

Accepted answers

All comments

SJ Sellers

Hi @Warren123

Very strange - I tried this myself and was able to get the correct result when cross-referencing it in another grid.

How is your time column formatted? What Formula are you using when you are inserting the reference? (for context, I used MAX and then inserted the reference which resulted in the attached screenshot.

As a side note, you could also capture the time using: =RIGHT(Created@row, 8)

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.