Convert date from one cell to text in another cell

Bryce Merrill
Bryce Merrill ✭✭
edited 01/12/21 in Formulas and Functions


I am trying to convert a date in one cell to text in another cell, but have not been able to figure out an eloquent/simple formula to do so.

The use case is: I have a planned start date column where the cells are populated with dates. I want to have that date translated into a Month label (drop down) in another column within the same row. So for example, my Planned Start Date is 1/15/2021, I want the "Month" column to show January in the cell on the same row.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!