How to remove the "0" that appear in front of my (text) after converting the (date).

I am using this formula to convert the numerical date to a text Month only. It works, however there is now a zero in front of the text. Does anybody have a suggestion for a solution.


=IF(MONTH(Created@row) = 1, "January") + IF(MONTH(Created@row) = 2, "February") + IF(MONTH(Created@row) = 3, "March") + IF(MONTH(Created@row) = 4, "April") + IF(MONTH(Created@row) = 5, "May") + IF(MONTH(Created@row) = 6, "June") + IF(MONTH(Created@row) = 7, "July") + IF(MONTH(Created@row) = 8, "August") + IF(MONTH(Created@row) = 9, "September") + IF(MONTH(Created@row) = 10, "October") + IF(MONTH(Created@row) = 11, "November") + IF(MONTH(Created@row) = 12, "December")

Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    Nested basically takes the 2nd IF and places it inside of the third portion of the 1st IF. The 3rd IF gets nested in the third portion of the 2nd IF. The 4th IF gets nested in the third portion of the 3rd IF. The 5th IF gets nested in the third portion of the 4th IF. So on and so forth. There are A TON of examples (mostly dealing with RYG type columns for "health") here in the community.


    =IF(1st argument, true_value, IF(2nd argument, true_value, IF(3rd argument, true_value)))

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!