Formula for finding across two smartsheets

SML ✭✭✭✭
edited 03/14/23 in Formulas and Functions


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?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!