Join Formula with Dates changing date format

Vasanth Balakrishnan
Vasanth Balakrishnan ✭✭✭
edited 06/07/24 in Formulas and Functions

if i use the join formula, updated date format in 'Start Test' column is not getting displayed, in 'UPDATED TIME FORMAT' it defaults to Smartsheet date format.

Capture.JPG
· Share on FacebookShare on Twitter

Answers

  • Mark.poole
    Mark.poole Community Champion
    edited 06/07/24

    @Vasanth Balakrishnan

    Try

    =1+","+Right([Start Test]@row,10)+","+[Start Time]@row+","+Right([End Test]@row,10)+","+[End Time]@row

    For the 1 Just add what ever your pulling into it to pull that digit. I know its a little clunkier then the Join function. how ever it is how you bypass smartsheet being smartsheet. lol

    If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.

    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!