Formula for finding across two smartsheets
Hi-
I have two Smartsheets that share a 'Group' column and a 'Study' column. If I wanted to find out if there are studies that appear in both 'Group' columns, how would I write the formula? Could I use cross reference?
Answers
-
Hi @SML
Yes, you could use a cross-sheet COUNTIFS formula, however I would potentially suggest using a Report instead! If you're on a Business or Enterprise plan, you could create a Row Report, Group by the Group column, and then use the Summary feature to count if there are any duplicates across both your sheets.
Here's a free webinar that goes through these features: Redesigned Reports with Grouping and Summary Functions
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
Hi Genevieve
Thanks, I pulled the two sheets into a report, and grouped by group. When I summarize the count of group, it just lists what is under each group, not the duplicates. How would I have the report just show me the duplicates?
-
Hi @SML
The Reports should then show you how many rows have that same "Group" listed. Meaning if your summary shows 1, there are no duplicates. If your summary shows 2+, then that group has a duplicate!
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
Thanks for your help
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!