Check box selection - referring multiple sheets

Joseph Aloysias
Joseph Aloysias ✭✭✭✭✭
edited 06/23/23 in Formulas and Functions

I have multiple sheets(sheet1,sheet2,sheet3,sheet4,sheet5) with email id's and I want to cross check in one master sheet in one check box column, if the match found then it should check the checkbox.

can we use index match formula to refer multiple sheets?

I'm trying to delete the master sheet email address if any of the email address are deleted from any of the 5 sheets. please help me with the workaround and formula



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!