I am building a spreadsheet that has to tab (sheets), the 1st I have an "assessment checklist" with about 250-30 checkboxes based on what is found. Example (Checkbox is in "A" column and description is in "B" column). I would like the description based on each checkbox "checked" to populate into a summary on the 2nd tab (sheet).

Is this something that can be accomplished at all, and is this something that can be done using a running report with a date?

For instance (Date 1/1/11 and summary in column "A of sheet two", Date 1/18/11 and summary in column "B of sheet two"... etc.

  • pls share a copy of your sheet – user0 Apr 17 at 21:52
  • Welcome. Please add a brief description of your search/research efforts as is suggested in How to Ask. – Rubén Apr 17 at 22:04

=QUERY(Sheet1!A:B, "select B where A=TRUE", 0)


  • This is one of many alternatives. Please add a brief explanation to explain how this work specially because QUERY isn't a common spreadsheet function. – Rubén Apr 17 at 22:06

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.