caciliberti
New Member
- Joined
- May 21, 2015
- Messages
- 8
- Office Version
- 365
- Platform
- Windows
Hello, I need to create a table with rows where I have a budget and % completion for each week of the month.
I need every week to update the % completion and based on the budget a Total for the week will be updated so I can use that value for weekly payments and then save it as a total paid with the rest of the rows in the table.
The following week to do the same until % completion reaches 100% or goes over budget.
The table is like this but with multiple rows:
For the following week "Total Week" should be again $0 until I add a % completion. But I should be able to go back to "Week Jan 17" and be able to see $250 or $400 if I need to. I had the idea that the "Total Week" could be done with a predefined Drop Down list and values would change based on that but I could not make it work.
I hope this is clear. Thank you!
I need every week to update the % completion and based on the budget a Total for the week will be updated so I can use that value for weekly payments and then save it as a total paid with the rest of the rows in the table.
The following week to do the same until % completion reaches 100% or goes over budget.
The table is like this but with multiple rows:
| Item | Budget | Complete % | Total Week Jan 17 |
| Demolition | $1000 | 25% | $250 |
| Walls | $2000 | 20% | $400 |
For the following week "Total Week" should be again $0 until I add a % completion. But I should be able to go back to "Week Jan 17" and be able to see $250 or $400 if I need to. I had the idea that the "Total Week" could be done with a predefined Drop Down list and values would change based on that but I could not make it work.
| Item | Budget | Complete % | Total Week Jan 24 |
| Demolition | $1000 | 10% | $100 |
| Walls | $2000 | 10% | $200 |
I hope this is clear. Thank you!
