Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAHere's my take
Like many others I didn't see the need to use a multi-row formula tool. I did make it dynamic enough that one could change the allowance amount or the amount to be spent weekly to see different outcomes.
Since it was just 4 weeks, I found it quicker to just write formulas for each week. However, I can see where if you were doing this over a longer period it would make sense to use Multi-Row Formula.
My solution. My approach is pretty brute-force. I'm not sure if there is a way to make this more dynamic/scalable in case the number of records or the number of weeks increases/decreases for any reason.
Solution with 5 formulas with user constants. Is there a possible solution with using 2 or less tools with a single expression calculating and assigning the values for all 5 distinct fields?