Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!
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. 🙂
