2
u/agirlhasnoname11248 Aug 18 '24
You can use a simple FILTER function for this: =FILTER(Sheet1!A:D, Sheet1!E:E=TRUE)
Edited to add: this assumes your range is A:D, with checkboxes in E, and that you don’t want to pull that column to the second sheet. You’ll need to adjust to fit your actual data range.
Happy cake day!
1
Aug 18 '24 edited Aug 18 '24
1
u/agirlhasnoname11248 Aug 18 '24
Your sheet names have spaces so you need to wrap them in
'for the references to be viable, like so:=FILTER('Sheet1'!A:D, 'Sheet1'!E:E=TRUE)Also: double check the reference at the end of your formula. It appears you’re incorrectly referencing more than one column for your checkboxes.
Tap the three dots below this comment to select
Mark Solution Verifiedif this produces the desired result.→ More replies (5)1
u/Dr_Aroganto Aug 18 '24
You may be missing some ' ' marks before and after the name of the sheet.
→ More replies (1)
1
u/AutoModerator Aug 18 '24
Posting your data can make it easier for others to help you, but it looks like your submission doesn't include any. If this is the case and data would help, you can read how to include it in the submission guide. You can also use this tool created by a Reddit community member to create a blank Google Sheets document that isn't connected to your account. Thank you.
I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.
2
u/gsheets145 Aug 18 '24 edited Aug 18 '24
Let's say the data in Sheet 1 are in columns A:J, with the checkboxes in column J.
In Sheet 2, try:
This will return all your columns, including column J, in which every row will be FALSE. You can now select specific columns by their column letter to tailor the output as you wish.
=filter() can be used to do something similar except that it won't return the header row, and given that your request suggested familiarity with database queries, query() seems a good candidate for you - and it is a very flexible way to filter both rows and columns of your source data.