Skip to main content
Language Selector

  1. Other Languages

    (machine translation)

Planview Customer Success Center

IsNull Function

  1. Last updated
  2. Save as PDF

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