Join Formula with Dates changing date format

Options

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.

Answers

  • Mark.poole
    Mark.poole ✭✭✭✭✭✭
    edited 06/07/24
    Options

    @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.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!