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
-
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
-
I don't see where the zero would be coming from. Is that the full formula, or is that a portion of a larger formula?
-
That would be the full formula. So the formula is not generating the problem. Perhaps it is the way the sheet is set up.
-
Are you able to provide some screenshots? If that is the full formula, then I have no idea where the zero is coming from just by looking at that bit.
-
Here you go. The Month row is where the 0s are. I have been able to successfully edit them out in the pivot table so that they appear without the 0s. But knowing why would be good.
-
Try adjusting the formula so that it is ""nested" instead of "added". I get the feeling that if the month ends up being January then there won't be a zero in front of it.
-
Good morning Paul,
Thank you for your help, forgive my ignorance, but could you provide an example of what, "nested vs added" looks like. I understand that my formula is added.
-
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)))
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!