Hi, I'm trying to create a budget spreadsheet that will have 3 columns:task. % allocated. $ amount.so for example: if the total budget is $100:task 1. 20%. $20task 2. 50%. $50etc. For some reason, I can't seem to input a formula on the $ amount column, in order to automatically calculate the $ based on the % from total. I've tried $=%*total, or $=total/%, but the result is so odd. it shows it momentarily, but won't update based on changes I make. it also won't copy the formula to bellow rows, it only copies the specific value (even though it does show the correct formula). I don't know if this matters, but this is all in a table (does that have an effect on formulas?). I've attached screenshots bellow. anyone please have any idea why this is happening or how to fix it? Thank you!

stpstein entirely possible that it's a Table thing. What you did is what I was thinking...and that should copy down the rest of the column too!

stpstein If you use Tables better to work with structured references.

stpstein Add nothing manually, use column name as it is.

stpstein Why don't you use absolute references, e.g. =$D$2/[@[Allocation %]]

SergeiBaklan I don't know why it won't accept anything? I feel like it's such a simple formula.. (screenshot attached)

PLEASE HELP! Budget formula won't work | Microsoft Community Hub