Auto fill information in sheet when a check box is checked in a different sheet?

Lexie Ozolnieks

Hi! I am trying to figure out how to auto fill information into my sheet, when I check a box in a different sheet. Essentially, all I want to do is autofill the check box on sheet 2 once it is checked on sheet 1. Is this possible?

Paul Newcome

Ok. Using the appropriate steps to create cross sheet references, your formula is going to look something along the lines of...

=IFERROR(INDEX({Other Sheet Checkbox Column}, MATCH([Unique Column]@row, {Other Sheet Unique Column}, 0)), "")

Paul Newcome

It is very possible. Do you have a column or series of columns that has unique data per row that matches up in both sheets?

Lexie Ozolnieks

Yes and No. Sheet 1 contains a form with some additional columns, one of which is the check box. Unique data to match sheet 2 will only appear if/when the form is submitted for that specific customer. Does that make sense?

Paul Newcome

It does make sense. Is it a single column or a series of columns that provides the unique data by row?

Lexie Ozolnieks

A single column

Paul Newcome

Ok. Using the appropriate steps to create cross sheet references, your formula is going to look something along the lines of...

=IFERROR(INDEX({Other Sheet Checkbox Column}, MATCH([Unique Column]@row, {Other Sheet Unique Column}, 0)), "")

Lexie Ozolnieks

That worked, thank you!

Paul Newcome

Happy to help! 👍️