Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Project budgeting

Options
Mohammed
Mohammed
edited 08/27/17 in Archived 2017 Posts

Hi

I'm maintaining a project budget sheet but i am having a problem with a formula i have applied same formula to all columns but last column is not being linked to the total formula bar. 

I am using the formula =sum(children()) for all columns, can you assist me in figuring this out

Tags:

Comments

  • Shaine Greenwood
    Options

    Hi Mohammed,

    To clarify, do you have a SUM(CHILDREN()) formula in all of your columns, and then a different formula that calculates the grand total from all of your SUM(CHILDREN()) formulas?

    If that's the case, you'll need to reference the last column's SUM(CHILDREN()) cell in your grand total formula.

This discussion has been closed.