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?


  • Jeff Reisman
    Jeff Reisman ✭✭✭✭✭✭

    @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


    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.


    Jeff Reisman

    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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!