We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

Do these featured exist? list all rows with the "N" column being less than 100

asked 2019-05-07 16:51:08 +0200

squoril gravatar image

updated 2020-08-03 12:40:31 +0200

Alex Kemp gravatar image

Im building a tracking spreadsheet and would like to have an overview page showing whats coming due soon

I have a sheet with a time remaining column holding a decimal number

I would like to have a seperate sheet thats shows all the rows with less than 100 in the time remaining column

What tools "keywords" should i be learing about

LONG VERSION I have 4 sheets, overview, hourly, calendar, and cycles. I want the overview page to show from each sheet the hourly rows with less than 100, calendar rows with less than 12 months, cycle rows with less than 500

I have the sheets set up to where you have one hour, cycle and date input and calculates all the remaining values. What i have no idea how to do, or even if it can be done is extracting the relevant rows and displaying them accordingly

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2019-05-07 17:07:32 +0200

karolus gravatar image

have a look on

>Data > Filter > Standardfilter …

edit flag offensive delete link more


If you want some excerpts to be copied to overview table, I'd suggest to go for Data -> Tools -> Advanced Filter since this includes a "Copy results to" option / functionality.

Opaque gravatar imageOpaque ( 2019-05-07 18:53:01 +0200 )edit

@Opaque: …as well the Standardfilter does!

karolus gravatar imagekarolus ( 2019-05-07 19:05:32 +0200 )edit

:-) Thanks, never noticed.

Opaque gravatar imageOpaque ( 2019-05-07 19:33:40 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-05-07 16:51:08 +0200

Seen: 34 times

Last updated: May 07 '19