Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
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
