simplifying formula/workflow

macd

Hi all, attached are 3 screen shots of a wfl i inherited. I was wondering if there's a way to simplify these formulas where there's an individual step to select a field and then append information to the data for each month of the year. If there's a way to do if then or case or anything to make it look less daunting, would greatly appreciate the help. Thanks.

here's the formula to append:

"04/25/" + ToString(DateTimeFormat(DateTimeAdd(DateTimeToday(),-1,"years"),"%y"))

formulafield selectionoverview

Garrett

If I'm reading this correctly, my approach would like be to Transpose and then use a single Formula toll with an If-Then statement. See attached.

Simplifying_Formula.yxmd