Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Date Formula

Options
buffie
buffie ✭✭
edited 12/09/19 in Archived 2017 Posts

I am having trouble converting this excel formula =TEXT(C7,"mmm-yyyy") to the Smart

sheets equivalent. Can someone help me?

 

 

 

· Share on FacebookShare on Twitter

Comments

  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭
    Options

    Question. Why are you trying to convert a date to a text format? What is the goal/outcome? 

     

    · Share on FacebookShare on Twitter
  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭
    edited 11/23/17
    Options

    Buffie,

    Not directly. Smartsheet does not have a correlation between the month number and the text name or short name. 

    If you set up a table somewhere in your sheet to house this information, however, it can be done.

    For the data shown in my screen shot below, the formula (in the green cell row 148) is

    =LOOKUP(MONTH(Date148), Description$134:[Table 2]$146, 2) + "-" + YEAR(Date148)

    I hope this helps.

    Craig

    mmm-yyyy_example.png

    · Share on FacebookShare on Twitter
This discussion has been closed.

Categories