Set as document filter

Set as document filter

Setting a filter as the document filter means the specified filter will be applied to all the users who are opening the spreadsheet for the first time until the filter is either removed or replaced with another. The published version of the file will also have the document filter.

  1. Select the required filter range and click on the Filter icon  in toolbar or go to Data > Filter.
  2. Apply the required filter conditions by clicking on the corresponding filter icon in the column.
  3. Once the filter condition is applied, click on the drop-down arrow in the filter icon  in toolbar and choose Set as Document Filter.
  4. The current filter will be set as the document filter.

Note: The filter that is currently visible on the sheet alone will be retained during file export. The other named filters will not be available in the exported file.

    • Related Articles

    • Filter users

      Advanced filters can be used to generate a list of specific users, and perform bulk actions on them.  Advanced filter  Sign in to the Zoho One Admin Panel. Click on Users. Click  in the top-right corner. Set the filtering criteria, then click Apply.

    • Filter Deals

      When there are lot of records in the Deals module, using filters will help find the required set of records easily. There are various set of advanced filters available such as: Time based filters, based on activities carried out,  deal stage, email ...

    • Set criteria

      Criteria are the fundamental filters of Conditional Assignment. To add a criteria: Choose Users matching the criteria when configuring the rule. Choose an attribute to filter users with. Set the value for the criteria, and the relationship between ...

    • Sort or filter files and folders

      Sort files and folders Sort files and folders in a Team Folder or My Folders by Name, Last Modified, or Created Time for easier access. To sort files and folders: 1. Go to a Team Folder or My Folders in Zoho WorkDrive. 2. Select the Sort by icon  on ...

    • How to dynamically filter a multiselect field

      The method of filtering a multi-select field is very similar to dynamically filtering single-select dropdowns as described here. However, the problem with filtering a multiselect is that when you edit the record the filtered list is not shown and all ...