Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAUsed slightly different Tools but overall same approach as provided Solution 🙂
- Used Multi-Row Formula to get month Numbers based on date Length (loved solution provided nested formula to achieve this with simple the formula tool!)
- Used Formula to convert Int values to 3 letter Month
- Used Multi-Field Formula to Populate current year based on if it was first month
- Used Multi-Row Field to Populate correct year across all Rows
- Select to Rename and drop unnecessary Fields
Felt like this was one of my uglier solutions. I still need to get more proficient with the multi row formula tool.
Here's my solution with only 2 tools 🙂
Kind of ugly but it works