Join formula of two sheets

Options


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 ✓
    Options

    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

    www.adapture.com

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

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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!