Date number to Reg date
I am looking to change a number in a date to just the month. So 01/01/23 will be January.
In regular excel I can use the =text function. But I can not do that for smart sheet.
What formula do I need?
Answers
-
@BlakeView I keep a sheet called "Month" just for the purpose of performing this lookup on many different projects.
You need a column for MonthNumber and one for MonthName, then just fill them with a row for each month:
1 January
2 February
etc
On your other sheet, use a formula like this:
=INDEX({reference the MonthName column from your Month sheet here}, MATCH(MONTH(DateColumnNameHere@row), {reference the MonthNumber column from your Month sheet here}, 0))
In English, give me the value from MonthName column where the MonthNumber matches the month in this date value.
Regards,
Jeff Reisman, IT Business Analyst & Project Coordinator, Mitsubishi Electric Trane US
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
Help Article Resources
Categories
Check out the Formula Handbook template!