Is there any option for short date that is MMM/YY e.g Sep-21

04/21/21
Answered - Pending Review

Currently have sheet that is in short date MMM/YY. We are trying to move this sheet across to smart sheet but an interim period we will still run Excel and copy back over that sheet so consistent format would make thing easy

Answers

  • Bassam KhalilBassam Khalil ✭✭✭✭✭

    Hi @Mike DeLuca

    Hope you are fine, Unfortunately, this feature is not currently available. You can submit a Smartsheet Product Enhancement Requests using this form.

    but you can play around by using a helper column to convert the short date MMM/YY to long date dd/mmm/yyyy or any format you need.

    if you want me to do it for you, Please add a copy of your sheet or a screenshot (after removing or replacing any sensitive information). This will make it easier for me to provide the appropriate answer to your question.

    Best Regards

    Bassam.M Khalil


    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as the accepted answer. It will make it easier for other Smartsheet Community members to find this solution or help to answer their questions.

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    The data will pull over, but it will pull over as a text value and not a date value. To convert it to a date in a separate column, there are a few different options. The best option would depend on your setup and a few details such as would you want all entries to be converted to the same day of the month such as the first or the fifteenth or would you want to be able to specify the actual day and just automate the year and month?

Sign In or Register to comment.