CODEWITHSUNDEEP
if-statementcheckboxgoogle-sheetsgoogle-sheets-formulags-vlookup
JRussell
JRussell

Reputation: 1

Creating a list of CheckBoxed items across multiple google sheets

I'm struggling to find the right formula to do a relatively simple task. I have a google sheet document with multiple sheets that have items listed each with a checkbox. I'd like to have each item that is checked be returned in a separate sheet in order to create a list. I've tried a few VLOOKUP formulas as well as combinations of IF/MATCH logic to get there but nothing seems to be working. Here's what I'm looking at:

enter image description here

Id like the list to return the "Item Location" for each column with a checked checkbox.

Upvotes: 0

Views: 479

Answers (1)

player0
player0

Reputation: 1

try:

=TRANSPOSE(FILTER({Sheet1!6:6, Sheet2!6:6}; {Sheet1!2:2, Sheet2!2:2}=TRUE))

0

Upvotes: 1

Related Questions