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
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.3K Get Help
 364 Global Discussions
 199 Industry Talk
 428 Announcements
 4.4K Ideas & Feature Requests
 136 Brandfolder
 127 Just for fun
 128 Community Job Board
 444 Show & Tell
 28 Member Spotlight
 1 SmartStories
 283 Events
 35 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!