Comparing Two Lists

Options

I have 3 lists that I normally copy into excel columns: #1 Roster names, #2 Split names, and #3 Audit names . I ensure all 3 sheets have the same corresponding names (often times some fall through the cracks and we lose names between each list) In excel I was using the following equation but I want to move it to smartsheets:

=FILTER(Table3[Split ], ISNA(XMATCH(Table3[Split],Table3[Roster],0)))

any ideas? essentially I need a list of the names missing from the roster on the split & the ones missing from the split on the audit (hoping that makes sense)

Answers

  • Ryan Sides
    Ryan Sides ✭✭✭✭✭✭
    Options

    Hi A, I'm not sure if there's a slicker solution for this or not, but if you're wanting to include them in the same sheet, you can use a COUNTIFS function that will count the first list for any instances of the name in the second list. If your count is zero, then you know it's not there. Create multiple count columns for your different scenarios.

    Does that so what you were wanting to do?

    Ryan Sides

    Smartsheet Tips and Tricks for Beginners and Advanced on LinkedIn and YouTube

    Come Say Hello!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!