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
buffie
✭✭
I am having trouble converting this excel formula =TEXT(C7,"mmm-yyyy") to the Smart
sheets equivalent. Can someone help me?
Comments
-
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
This discussion has been closed.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 410 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives