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

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:
· Share on FacebookShare on Twitter

Comments

  • Shaine Greenwood
    Shaine Greenwood Employee

    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.

    · Share on FacebookShare on Twitter
This discussion has been closed.

Categories