Financial examples use US dollars.
Returns projects that do not match the specified value, for example, "Project Risk Is Not Low".
Returns projects that include any of the specified values, for example, use this condition to find projects in Buenos Aires, London, or San Francisco.
Returns projects that do not include any of the specified values. For example, use this condition to find projects in all locations except London.
Returns projects that include any value in the specified field.
Returns projects that do not include any value in the specified field. For example, use this condition to find projects that are missing values in required fields.
Returns projects that include date values in the selected time period. For example, use this condition to find projects that are due in the next seven days, or to find projects that were approved in the previous year.
Returns projects that include values within a specified date or financial range, including the end-points of the range.
In this date example, "Actual Start Date Between Exclusive 1/1/22 and 3/3/22" returns any project that has a start date within the range of 1/1/22 and 3/3/22, including 1/1/22 or 3/3/22.
In this financial example, "Hard Savings (Final) Between Inclusive 1 and 30000" returns any project that has final hard savings within the range of $1 and $30,000, including $1 or $30,000.
Projects that include values within a specified date or financial range, not including the end-points of the range.
In this date example, "Actual Start Date Between Exclusive 1/1/22 and 3/3/22" returns any project that has a start date within the range of 1/1/22 and 3/3/22, but not including 1/1/22 or 3/3/22.
In this financial example, "Hard Savings (Final) Between Exclusive 1 and 30000" returns any project that has final hard savings within the range of $1 and $30,000, but not including $1 or $30,000.
Returns projects that include the specified value for the specified field. For example, "Project Name Contains Defect" returns Defective Parts, Defects on Paper Line 6, and Reducing Defects.
Projects that do not include the specified value for the specified field. For example, "Project Name Does Not Contain Defect" returns projects that do not include Defect in their names.
Projects where the specified field starts with the specified value. For example, "Project Name Starts With Defect" returns Defective Parts and Defects on Paper Line 6, but not Reducing Defects.
Projects where the specified field ends with the specified value. For example, "Project Name Ends With Reduction" returns Repackaging Reduction, Grinding Disc Scrap Reduction, and Syringe Molding Waste Reduction, but not Reduction on Line 8.
Projects that are less than the specified value. For example, use this condition to find projects where hard savings are less than $500,000.
Projects that are less than or equal to the specified value. For example, use this condition to find projects where hard savings are less than or equal to $500,000.
Projects that are greater than the specified value. For example, use this condition to find projects where hard savings are greater than $500,000.
Projects that are greater than or equal to the specified value. For example, use this condition to find projects where hard savings are greater than or equal to $500,000.
Projects that are equal to the specified value. For example, use this condition to find projects where hard savings are equal to $500,000.
Projects that are not equal to the specified value. For example, use this condition to find projects where hard savings are not equal to $500000.
Projects that are before the specified date. For example, "Actual Start Date Before 1/1/21" finds projects that start before January 1, 2021.
Projects that are on or before the specified date. For example, "Actual Start Date On Or Before 1/1/21" finds projects that start on or before January 1, 2021.
Projects that are after the specified date. For example, "Actual Start Date After 1/1/21" finds projects that start after January 1, 2021.
Projects that are on or after the specified date. For example, "Actual Start Date On Or After 1/1/21" finds projects that start on or after January 1, 21.