SP.FILTER

SP.FILTER returns an array of property codes based on a series of up to five filters. This is primarily designed to be used in combination with SP.FINANCIALS_AGG.

SP.FILTER has the following arguments, which can either be entered directly into the formulas surrounded by quotation marks, or entered by cell reference (A1).

Property Codes (OPTIONAL) - a list of singlepane property codes to limit the set to. This can be useful when you wish to exclude certain hotels. For example, you might want to filter for all Resort properties, but want to exclude 3 properties from the returned list. In order to do this, you would pass the entire list of portfolio properties, except the 3 to exclude to this argument. If left blank, it will filter starting from all hotels that your user account can access.

Filter1 - the name of the first filter to use. Available filters are:

1. Ownership

2. ManagementCompany

3. HotelCompany

4. Brand

5. ManagedOrFranchised

6. Market

7. STRMarketClass

8. RoomRange

9. Union

10. Rooms

11. AssetManager

12. Fund

13. Lender

14. ServiceLevel

15. ProductType

16. InvestmentStage

17. MeetingSpaceSqft

18. UDF1 Through UDF20

Value1- the value(s) to include for Filter1. When including multiple values, either pass a range reference or a comma seperated list in quotes ("Resort, Urban")

Filter2..5 (OPTIONAL) - the same as filter 1.

Value2..5 (OPTIONAL) - the same as value 1.

=SP.FILTER(,"ProductType","Resort,Urban")

Will return the list of codes from the full portfolio which are either Resort or Urban.

Reference the "My Properties" tab for the values of each available filter field by hotel.