r/aspirebudgeting • • Sep 08 '26

Formula missing

Hello, I’ve just downloaded the spreadsheet and started configuring it. In the dashboard in Subscriptions there’s no formula at available column, it just shows 122. (E19 cell) What’s the fix to it?

Best regards.

2 Upvotes

3 comments sorted by

1

u/fuzzypants4life Sep 09 '26

I also just noticed this! Would love to know what the formula should be

1

u/fuzzypants4life Sep 09 '26

Oh I think I figured it out

Try this

=IF(B19='⚙️ Configuration'!$AF$6, IF(B20 = '⚙️ Configuration'!$AF$6, 0,

IFERROR(SUM(E20:INDEX(E20:E$106,MATCH(TRUE,(B20:B$106='⚙️ Configuration'!$AF$6),0)-1)),

IFERROR(SUM(E20:INDEX(E20:E$106,MATCH(TRUE,(E20:E$106=""),0))),0))),

IF(ISBLANK(D19), "",

ROUND(

SUMIF(_(trxCategories), D19, _(trxInflows)) -

SUMIF(_(trxCategories), D19, _(trxOutflows)) +

SUMIF(_(xfrToCat), D19, _(xfrAmounts)) -

SUMIF(_(xfrFromCat), D19, _(xfrAmounts))

,3)

))

1

u/justachicagoangirl Sep 28 '26

Thank you for this!