You can specify criteria to create filters for summaries or dashboard reports using the following conditions.
Note

For date fields, when Value is @TODAY@, the filter returns results for the day the filter is applied, not the day it was created.

Condition Results

Is

Projects that match the specified value.

For example, "Project Risk Is Low".

Is Not

Projects that do not match the specified value.

For example, "Project Risk Is Not Low".

Is Any Of

Projects that include any of the specified values.

For example, use to find projects in Buenos Aires, London, or San Francisco.

Is None Of

Projects that do not include any of the specified values.

For example, use to find projects in all locations except London.

Has Value

Projects that include any value in the specified field.

Note

For Text and Formula (Text) fields, a space is not a value. For Rich Edit fields, a space or a hard return is not a value.

Does Not Have Value

Projects that do not include any value in the specified field.

For example, use to find projects that are missing values in required fields.

Is In

Projects that include date values in the selected time period.

For example, use to find projects that are due in the next seven days, or to find projects that were approved in the previous year.

Note

When the selected time period is within days, results include the current day. When the selected date range is within the quarter or the year, results are based on the fiscal year.

Between Inclusive

Projects that include values within a specified date or financial range, including the end-points of the range.

A date example: "Actual Start Date Between Exclusive 1/1/12 and 3/31/12" finds any project that has a start date within the range of 1/1/12 and 3/31/12, including 1/1/12 or 3/31/12.

A financial example: "Hard Savings (Final) Between Inclusive 1 and 30000" finds any project that has final hard savings within the range of $1 and $30,000, including $1 or $30,000.

Between Exclusive

Projects that include values within a specified date or financial range, not including the end-points of the range.

A date example: "Actual Start Date Between Exclusive 1/1/12 and 3/31/12" finds any project that has a start date within the range of 1/1/12 and 3/31/12, but not including 1/1/12 or 3/31/12.

A financial example: "Hard Savings (Final) Between Exclusive 1 and 30000" finds any project that has final hard savings within the range of $1 and $30,000, but not including $1 or $30,000.

Contains

Projects that include the specified value for the specified field.

For example, "Project Name Contains Defect" finds Defective Parts, Defects on Paper Line 6, and Reducing Defects.

Does Not Contain

Projects that do not include the specified value for the specified field.

For example, "Project Name Does Not Contain Defect" finds projects that do not include Defect in their names.

Starts With

Projects where the specified field starts with the specified value.

For example, "Project Name Starts With Defect" finds Defective Parts and Defects on Paper Line 6, but not Reducing Defects.

Ends With

Projects where the specified field ends with the specified value.

For example, "Project Name Ends With Reduction" finds Repackaging Reduction, Grinding Disc Scrap Reduction, and Syringe Molding Waste Reduction, but not Reduction on Line 8.

Less Than

Projects that are less than the specified value.

For example, use to find projects where hard savings are less than $500,000.

Less Than or Equal To

Projects that are less than or equal to the specified value.

For example, use to find projects where hard savings are less than or equal to $500,000.

Greater Than

Projects that are greater than the specified value.

For example, use to find projects where hard savings are greater than $500,000.

Greater Than or Equal To

Projects that are greater than or equal to the specified value.

For example, use to find projects where hard savings are greater than or equal to $500,000.

Equal To

Projects that are equal to the specified value.

For example, use to find projects where hard savings are equal to $500,000.

Not Equal To

Projects that are not equal to the specified value.

For example, use to find projects where hard savings are not equal to $500000.

Before

Projects that are before the specified date.

For example, "Actual Start Date Before 1/1/12" finds projects that start before January 1, 2012.

On or Before

Projects that are on or before the specified date.

For example, "Actual Start Date On Or Before 1/1/12" finds projects that start on or before January 1, 2012.

After

Projects that are after the specified date.

For example, "Actual Start Date After 1/1/12" finds projects that start after January 1, 2012.

On or After

Projects that are on or after the specified date.

For example, "Actual Start Date On Or After 1/1/12" finds projects that start on or after January 1, 2012.

By using this site you agree to the use of cookies for analytics and personalized content.  Read our policy