Skip to main content

 

Planview Customer Success Center

IsNull Function

IsNull (value as Object) as Boolean

Category: Logical
Description: Returns TRUE if a given field name or value is NULL
Supported Context: FormulaField And BusinessRules
Parameters:  
value as Object Represents a specific object field
Returned value as Boolean Returns a boolean value, where "TRUE" indicates that the field specified in the "value" parameter is null
Example #1

Set a validation rule for Issues that won't allow the 'Issue State' field to be set to "In Work" if the 'target project' is not defined. To evaluation criteria should be:

IsChanged($State) && ($State = "In Work") && IsNULL($PlannedFor)

Example #2

Set a project sponsor to be NULL if the 'project type' is marked as internal. Create a workflow rule that will set the following evaluation criteria:

$ProjectType = "Internal"

To update the field within the workflow rule, add an "Update Field" action, select the 'Project Sponsor' field and set it to NULL.

Tips
  • To set standard field values based on formulas, create workflow rules
  • To set a field of any type to NULL, simply write NULL
Additional Links

Workflow Rules