Index Match/ V look up or Data Mesh?


Hi, I'm using Smartsheets to input all associated software release notes across many different software versions (each software version has a separate Smartsheet).

My issue is that sometimes certain tasks IDs appear in multiple versions of software. e.g. Task ID: 1234 may appear in software version V10 and V11.

I want to be able to know if a certain task ID appears in different versions across multiple sheets (I have about 20+ sheets) and I'll add some conditional formatting if it comes back as yes..

Would it be best to use Index Match or V Look up? Although I'm not sure if either would work across multiple sheets?

Or would Data Mesh be a viable option?

Thanks in advance!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!