Auto fill information in sheet when a check box is checked in a different sheet?
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?
Best Answer
-
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)), "")
Answers
-
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?
-
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?
-
It does make sense. Is it a single column or a series of columns that provides the unique data by row?
-
A single column
-
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)), "")
-
That worked, thank you!
-
Happy to help! 👍️
Help Article Resources
Categories
Check out the Formula Handbook template!
