Budget Rollup based on used Resources

I currently have this formula for my budget
=IF([Resource Helper column]@row > 4, [Quoted labor budget ]@row - (200 * ([Resource Helper column]@row - 4)), [Quoted labor budget ]@row).
I want to do a roll up each time an additional resource is added in the child rows and any additional rows for created for each project.
Im currently using 1 sheet for all of my projects
Answers
-
Can you explain more of what you are looking for? Would it be easier to jump on a quick zoom to look at your sheet and create a quick formula? If so - my calendar is linked below. Happy to chat with ya!
Michelle Choate
michelle.choate@outlook.com
Always happy to walk through any project you need help with! Book time with me here: https://calendly.com/michelle-choate
-
To create a roll up of all children rows (excluding any additional IF criteria) you can simply use a =sum(children()) on each parent row, so when a new child row (project) is created, the sum value will automatically update
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 487 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 74 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!