Search

Close

Start Free Trial

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

Fun challenge!

My gut deceptively wanted me to try this with an iterative macro until (see spoiler)

I remembered you can do more than a one step prior reference in the multi row tool :)

This was a fun challenge!

I had forgotten how fast Pell Sequence numbers can grow.

Screenshot 2025-02-10 161213.png

Solution attached.

WC 463_2-10-25.JPG

My solution.

Workflow

Multi-Row Formula
Pell_Sequence =
IF [RowCount] = 1 THEN 0
ELSEIF [RowCount] = 2 THEN 1
ELSE 2 * [Row-1:Pell_Sequence] + [Row-2:Pell_Sequence]
ENDIF

WorkflowMulti-Row FormulaPell_Sequence = IF [RowCount] = 1 THEN 0 ELSEIF [RowCount] = 2 THEN 1 ELSE 2 * [Row-1:Pell_Sequence] + [Row-2:Pell_Sequence] ENDIF

Screenshot 2025-02-11 133011.png

My solution!

My not use Multi-Row Formula solution.

Loop Expression

Live Weekly Challenge