Is this bug? - get AM/PM and Hour of created date

Options

1 - Number 1 sheet - I got AM/PM without error


I copied(By Workflow) Number1 Sheet(above) To Number2 Sheet(below)


2-Number2 sheet - I can't get AM/PM of copied value

I guess - that value is minute

can you help me?

😁

and

3.in reference of Number1 Sheet - same bug is appeared


Answers

  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭
    Options

    Good morning, I can't duplicate your error. Have you tried converting the AMPM column in the copied sheets to a column formula (=right(created@row,2)?

    Mark


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

  • SJENG ADMIN
    Options

    thank you for your reply

    ------ below is your reply ----

     Have you tried converting the AMPM column in the copied sheets to a column formula (=right(created@row,2)?

    ----- below is my reply ----

    No. If i convert AMPM in copied sheet, There must be same column name, (AMPM and AMPM1).

    thank you

  • MCorbin
    MCorbin Overachievers Alumni
    Options

    I couldn't duplicate it either. I would suggest reporting this to Support@Smartsheet.com


    They can look at what's going on behind the scenes.