Join formula of two sheets


Hello -

Shown is one sheet but two sources separate data . Can I combine the two counts anyway they have the same Primary column. I don't want to make a summary count of the two because I can't get rid of this in reporting.

Can you assist me with the formula? Thanks.

Best Answers

  • Ramzi
    Ramzi ✭✭✭✭✭
    edited 08/13/23 Answer ✓

    Here's another option:

    In your sheet, create a third section that adds the results of the first two. It would have the same rows, but the formula for each row would add the cells of section 1 + section 2.

    Add a helper column called ShowInReport as a Check Box and check all the rows in the third section.

    Create a report and tell it to show you only Section 3 (where the ShowInReport is true.

    I hope that makes sense.

    Smartsheet Solutions Architect

  • Marilen.Navarro103391
    Marilen.Navarro103391 ✭✭✭✭✭
    Answer ✓

    @Ramzi Helper is good. I got it. Thanks for your help


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!