Forum Discussion
Halloween 2026 Scheduling Challenge 🎃
Happy Halloween! You'll find the rules in the screen capture below and in the attached workbook. Creative solutions are encouraged. Feel free to use any functions available in the Beta ch...
My version:
=LET(
∂,M3:M10-SEQUENCE(,ROUNDUP(MAX(M3:M10)/2,0),2,2),
lst,TOCOL(
IF(
∂>=-1,
K3:K10&"🎃"&∂,
≠),
3,
1),
candies,TEXTBEFORE(lst,"🎃"),
qty,--TEXTAFTER(lst,"🎃"),
run,SCAN(
0,
1+(qty>=0),
SUM
),
HSTACK(
candies,
VSTACK(
0,
DROP(run,-1)
),
run
)
)The formula has made on italian Excel, and the translation maybe be not accurate, I attach the file to test it.
Bye