Skip to content
  • Try Smartsheet

    • Formulas and Functions

    Formulas and Functions

    Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

    Budget Rollup based on used Resources

    ✭✭✭
    in Formulas and Functions

    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

    image.png
    Tags:
    · Share on FacebookShare on Twitter

    Answers

    • 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

      · Share on FacebookShare on Twitter
    • ✭✭✭✭

      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

      Adam Stone - Founder

      www.apexconsultants.io

      Book a Meeting

      · Share on FacebookShare on Twitter

    Sign in
    Try Smartsheet

    Help Article Resources

    Create and edit formulas in Smartsheet

    Formula combinations for cross sheet references

    Smartsheet functions list

    Quick Links

    Categories

    Want to practice working with formulas directly in Smartsheet?

    Check out the Formula Handbook template!

    Trending in Formulas and Functions