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

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

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

If I understand you correctly, you can just add the two formulas together to get the total.
Smartsheet Solutions Architect
www.adapture.com

hello. yes I can add the two formula but when I make a Report, it will show these two tables. Is there a formula where I can combine the sum of two sheets?

You could potentially use the Group/Summarize features in the report. Will that work?
Smartsheet Solutions Architect
www.adapture.com

@Ramzi so it means I wouldn't be able to join a count of two sheets in table form?

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

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

@Ramzi I have another question, if you can help me set up with weekly count, starting September. I only know monthly, I haven't done weekly. Can you give me an idea? Thanks
Help Article Resources
Categories
Check out the Formula Handbook template!