Formula for finding across two smartsheets

SML

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?

Genevieve P.

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

SML

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?

Genevieve P.

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!

SML

Thanks for your help