Skip to main content

 

Planview Customer Success Center

In Function

In (field as Object, value1 as Object, value2 as Object, ... as Object) as Boolean

Category: Logical
Description: Returns true if a specified field value is equal to any of the supplied values
Supported Context: FormulaField And BusinessRules
Parameters:  
field as Object Represents a specific object field
value1 as Object Represents a potential value of the field specified in the "field" parameter
value2 as Object Optional parameter that represents a potential value of the field specified in the "field" parameter
... as Object Optional parameters that represent potential values of the field specified in the "field" parameter
Returned value as Boolean Returns a boolean value, where "TRUE" represents that the "field" specified has one of the values specified in the "valuex" parameters
Example #1

Create a workflow rule that will update the external user flag to false in case the user's email is one of the following domains: acme.co.us, acme.org, acme.com, acme.co.uk, etc. This will automatically set the 'external user; flag to FALSE, in case the email domain includes anything with acme.

Not(In($Email,"@acme."))

Example #2

Automatically set a user's default availability for new projects based on their job title. For example, if the user is a developer, DBA or QA engineer, they should only spend 70% of time on project related activities (as the remaining 30% is spent on maintenance work). Create a workflow that will update the 'Default Project Availability' field as follows:

If(In($JobTitle.Name, "Developer", "DBA","QA Engineer"), 70,100)

Tips To set standard field values based on formulas, create workflow rules