Can a checkbox in one sheet be auto-checked based on a checked checkbox in another sheet?

Options

Hi all!

Can a checkbox in one sheet be auto-checked based on a checked checkbox in another sheet?

I've looked through multiple help resources but can't seem to find a situation that specifically matches my set-up. Here's what I'm looking to do:

If the same Product Code exists in columns 1A and 1B, AND column 2A is checked, THEN column 2B is automatically checked.

It seems like the answer would be some sort of INDEX(MATCH combination, but I haven't been able to get the formula right while referencing both sheets.

Any help or advice would be much appreciated, thank you! šŸ™‚

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!