Combining multiple SS into one super sheet.

Options

Reema ✭✭

10/25/23 in Formulas and Functions

Hey everyone,

I have 12 individual project sheets with multiple columns. I want to pick up 7 columns from them and link all the data from those 12 sheets into a super sheet.

Is this possible in SS?

0 ·

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Trending in Formulas and Functions

Sum Multiple Criteria
I'm looking to sum the total in the CS Error Cost column anytime the Responsibility column equals CSC, ISG or UAL. I've attempted different nesting versions of the SUMIF and SUMIFS but keep getting an error. Below is one example of what I attempted. =SUMIF([CS Error Cost]:[CS Error Cost], Responsibility:Responsibility,…
IFERROR Formula Not Working
Good day, team. I have a formula that works as intended, which takes the latest row of children data and inputs that as the value. That formula is: =(INDEX(CHILDREN(), COUNT(CHILDREN()))) and produces the following results: However, if there is no data in the children cells it gives me an "Invalid Column Value" as shown…
Sum of child rows multiplied by other row.
Hello Community, Can the sum of child rows that are individually multiplied be achieved without the use of a helper column? I would like to be able to detail the total sum of the child rows [March 2025] multiplied by [Rate] without the use of a helper column. I =SUM(CHILDREN([March 2025]@row ) * CHILDREN(Rate@row ))…

Combining multiple SS into one super sheet.

Help Article Resources

Categories