Weekly Challenges
Solve the challenge, share your solution and summit the ranks of our Community!Also available in | Français | Português | Español | 日本語
IDEAS WANTED
Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEA
All,
Well this one was a bit tougher than I expected as I thought that there would be an easier solution than using RecordID and hard-coding and mixing in the Multi-Row Formula.
Nonethesless, i made it happen...
Spoiler
IF [RecordID] IN (1,13) THEN "Jan"
ELSEIF [RecordID] IN (2,14) THEN "Feb"
ELSEIF [RecordID] IN (3,15) THEN "Mar"
ELSEIF [RecordID] IN (4,16) THEN "Apr"
ELSEIF [RecordID] IN (5,17) THEN "May"
ELSEIF [RecordID] IN (6,18) THEN "Jun"
ELSEIF [RecordID] IN (7,19) THEN "Jul"
ELSEIF [RecordID] IN (8,20) THEN "Aug"
ELSEIF [RecordID] IN (9,21) THEN "Sep"
ELSEIF [RecordID] IN (10,22) THEN "Oct"
ELSEIF [RecordID] IN (11,23) THEN "Nov"
ELSEIF [RecordID] IN (12,24) THEN "Dec"
ELSE "NA"
ENDIF
ELSEIF [RecordID] IN (2,14) THEN "Feb"
ELSEIF [RecordID] IN (3,15) THEN "Mar"
ELSEIF [RecordID] IN (4,16) THEN "Apr"
ELSEIF [RecordID] IN (5,17) THEN "May"
ELSEIF [RecordID] IN (6,18) THEN "Jun"
ELSEIF [RecordID] IN (7,19) THEN "Jul"
ELSEIF [RecordID] IN (8,20) THEN "Aug"
ELSEIF [RecordID] IN (9,21) THEN "Sep"
ELSEIF [RecordID] IN (10,22) THEN "Oct"
ELSEIF [RecordID] IN (11,23) THEN "Nov"
ELSEIF [RecordID] IN (12,24) THEN "Dec"
ELSE "NA"
ENDIF
Cheers!
Matt
My solution.. Used a mod function to determine the month numbers based on the recordID. seems to work ok. 🙂
