|
Klassiske filtyper er ikke lenger tilgjengelige for bruk fra og med januar 2021. Du kan overføre klassiske filer eller laste ned en PDF-fil. Finn ut mer

Spreadsheet filters

Fullført
Be om demo

Excel has the =filter function which allows you to filter a range or an array.  You can use it to return multiple rows based on a value or values.

For example, from your current sheet you could return all rows from a connected sheet where "FY2020" is found in column A.

Will the =filter be added to Wdesk Spreadsheets?  I don't see it there now.

Is there another way in Spreadsheets to return multiple rows based on a value as described above?

Thanks,

Greg

 

2

Kommentarer

4 kommentarer

Dato Stemmer
  • Mike Davis

    Hi Greg!

    At quick glance, I'm not finding any existing requests for adding the =FILTER function in Spreadsheets. I'm happy to pass along your request, however, to test the waters a bit.

    I'll add too (though I'm sure you're aware) that you CAN apply a Filter to content in a Spreadsheet, but as a Filter itself, or a Filtered View. More info on Filters can be found here on our Help site: https://support.workiva.com/hc/en-us/articles/360035643312-Sort-and-Filter-Spreadsheets.

    Let me know if I've missed the mark there, or you have any questions for me. Thanks as always and have a great rest of your day!

    0
  • Rob Kutka

    This would be a helpful addition.

    0
  • Amy Jordan

    I also would like to see this function added.

    0
  • Brooke Mortvedt

    Hi all!

    Workiva recently made available the feature "Conditional Filtering" or Spreadsheets & it may meet some of your needs. More info is available on our Help site. If you find this does not quite meet your needs, let us know and we’ll be happy to get your feedback logged and continue tracking progress.

    Have a great day!

    0

Logg på for å legge inn en kommentar.