Date number to Reg date

BlakeView

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

@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.