Reply To: Comparing sheet data

Inner Circle › Ask Smartsheet Guru Crew Anything › Comparing sheet data › Reply To: Comparing sheet data

June 18, 2025 at 11:21 am #648
Michael Drayton
Participant

    I think IndexMatch better in this situation.

    goodpage = has the ids
    badpage = no ids
    = INDEX({Project Name badpage}, MATCH([Project Name]@row, {Project Name Lookupbadpage}, 0))

    put this in a helper column in the bad page.