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

Tags:

Answers

  • Michelle Choate 2
    Michelle Choate 2 Community Champion

    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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!