I am having trouble converting this excel formula =TEXT(C7,"mmm-yyyy") to the Smart
sheets equivalent. Can someone help me?
Question. Why are you trying to convert a date to a text format? What is the goal/outcome?
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
