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.

Consolidating project costs

MICHAEL CARTER
MICHAEL CARTER ✭✭
edited 12/09/19 in Archived 2016 Posts

How can I add the total cost of four projects that are detailed on four sheets to one cell in a master sheet? It seems you can only link a cell to a cell, not a cell to four cells to add them.

Comments

  • Atus Bartal
    Atus Bartal ✭✭✭✭✭✭

    Dear Michael,

    Yes, i think that's the way it works... I would link the four cells to the master sheet in a new column, SUM() them in the right place, and then hide the column.

    Atus

This discussion has been closed.