Inner Circle › Ask Smartsheet Guru Crew Anything › Comparing sheet data › Reply To: Comparing sheet data
June 18, 2025 at 12:53 pm
#653
I need to see which ID’s from the source sheet(good sheet) are not on the comparison sheet(bad sheet). The formula Peggy gave is so complex, I’m not understanding which sheet is which and where would my sheets fit into the formula.
The attachments you sent, I have to be in IG to see the formula example?
Also, would I add a helper column in the source sheet and do a he formula in one of those cells?