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

Challenge #21: Date Reformatting

aheikes
8 - Asteroid
Spoiler
Challenge21.JPG
SemihKumluk
7 - Meteor

I tried IF formula to extract Year, it is simpler to use Right(), if it is shorter than the String it doesnt operate.

I used [Year]=Null() to apply Multi-Row Formula, it doesnt work when I remove [Year] although I am working on the Year field.

MarielJinang14
7 - Meteor
Spoiler
Challenge #21.PNG

 Did a different solution. I find putting a record ID and input text is easier to do considering the data instead of the multi row formula for the month column. 

Ashley2
8 - Asteroid

Challenge 21 complete!

My Solution;

Spoiler
Ashley2_0-1586184617179.png

 

grossal
15 - Aurora
15 - Aurora

Time to work on these challenges!

Spoiler
grossal_0-1586515371223.png

 

Little trickery here 😉

Evgeny
7 - Meteor

Challenge completed.

 

Spoiler
Evgeny_0-1586563223760.png

 

cneivam
9 - Comet

Hello, follow attached my solution. I used one text input for helping the join.

Regards,

Neivam

LuciaC
7 - Meteor

My Solution

Spoiler
Challenge 21.PNG
steven4320555
8 - Asteroid

Used Record ID as string, and created a fake date, and extracte the month part.

Spoiler
steven4320555_0-1586716131540.png

 

Ben_Jeffreys
8 - Asteroid

My submission